Can you just run procsyst.sql to reinstall missing stored procedures in an existing sql installation? I am running sql v7 and at some point several stored procedures were removed for security reasons. I now need to get them back because I trying some new things in sql and keep getting errors about missing stored procedures. I am sure that running this in query analyzer will restore all of the stored procedures but I am concerned that it may overwrite some existing information back to default.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
procsyst.sql
- Thread starter tataylor
- Start date
JamesJKusch
MIS
As long as procsyst.sql does NOT include the DROP Procedure code, it will not over-write, recreate, the SPs that already reside.
J. Kusch
J. Kusch
- Status