MS SQL Server - Trying to recreate system stored procedures

Author

Trying to recreate system stored procedures

eli silverman

2006-03-27, 8:23 pm

I accidently deleted a number of system stored procedures from one of my end
user databases. (dt_addtosourcecontr
ol ...). Is their a way to recreate them,
shot of restoring the database?

Sue Hoegemeier

2006-03-28, 3:23 am

It shouldn't hurt anything in most cases. The dt stored
procedures are created when you use different visual
database tools against a database - the designers in
Enterprise Manager, Visual Studio tools, etc. They aren't
system stored procedures but Da Vinci tools (dt) stored
procedures for the database tools. Try creating a diagram
for the database if you want the tables back.

-Sue

On Mon, 27 Mar 2006 15:38:02 -0800, eli silverman
< elisilverman@discuss
ions.microsoft.com> wrote:

>I accidently deleted a number of system stored procedures from one of my end
>user databases. (dt_addtosourcecontr
ol ...). Is their a way to recreate them,
>shot of restoring the database?

Sponsored Links