Home > Archive > MS SQL Server > February 2006 > sql server 2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author sql server 2005
farshad

2006-02-28, 8:23 pm

Hi,
I am trying to script the creation of the Stored Procedures.
But can not get the script to have the bits for if exists then drop bit.
Thanks
Andrew J. Kelly

2006-02-28, 8:23 pm

You can't script the create and drop all at the same time. You have to
script the drops and creates in two passes. They left this feature out and
hopefully will be back soon.

--
Andrew J. Kelly SQL MVP


"farshad" <farshad@discussions.microsoft.com> wrote in message
news:4279FE96-FB31-4DA7-A0E7- D710599AC9FC@microso
ft.com...
> Hi,
> I am trying to script the creation of the Stored Procedures.
> But can not get the script to have the bits for if exists then drop bit.
> Thanks



Tibor Karaszi

2006-02-28, 8:23 pm

I believe that Bill's utility has drop options:

http://weblogs.sqlteam.com/billg/ar...11/22/8414.aspx

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

Blog: http:// solidqualitylearning
.com/blogs/tibor/



"farshad" <farshad@discussions.microsoft.com> wrote in message
news:4279FE96-FB31-4DA7-A0E7- D710599AC9FC@microso
ft.com...
> Hi,
> I am trying to script the creation of the Stored Procedures.
> But can not get the script to have the bits for if exists then drop bit.
> Thanks


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com