|
| CS 2.1 SP1 _Update.sql executed on "master" database |
 |
Tue, 5 Dec 2006 00:33:14 +0000 |
This may sound like a stupid question, and a stupid error on my part, but I have
excecuted the CS 2.1 SP1 upgrade SQL script on my MS SQL 2005's
"master" database. It said completed with errors, however from my view
of things it looks like the "master" database has only 6 tables. Will
I have damaged anything, and will I need to rebuild my MS SQL 2005
"master" database (as I did not have it backed up)?
I am very keen to check in case it affects future stability... many thanks for
your assistance,
ASW
|
| Post Reply
|
| Re: CS 2.1 SP1 _Update.sql executed on "master" database |
 |
Tue, 5 Dec 2006 00:43:23 +0000 |
Unfortunately I do see a whole bunch of cs_ sprocs listed on the master
database. Wondering if a database rebuild would solve this issue, which I'm
leaning towards at the moment.
ASW
|
| Post Reply
|
| Re: CS 2.1 SP1 _Update.sql executed on "master" database |
 |
Tue, 5 Dec 2006 16:29:36 +0000 |
I don't think other than the sprocs being in there will hurt anything because
they have the cs_ so if you are not having any issues with SQL server I would
not fix that which is not broken.
|
| Post Reply
|
| Re: CS 2.1 SP1 _Update.sql executed on "master" database |
 |
Tue, 5 Dec 2006 16:37:19 +0000 |
Do not try to restore you master database if at all possible, could prove to
cause many other issues that you don't want to have. The Wizard is wise obey
his suddle warning. Believe me I have been tortured by master db restores that
have gone wrong. You don't want that.
You could use Enterprise manager to delete the items one by one.
|
| Post Reply
|
| Re: CS 2.1 SP1 _Update.sql executed on "master" database |
 |
Tue, 5 Dec 2006 16:44:55 +0000 |
I agree with Tim, if you must then just delete the cs_Sprocs one by one. It
might also be good practice to backup the master before removing anything!
|
| Post Reply
|
|
|
|
|
|
|
|
|
|