Home All Groups Group Topic Archive Search About

SQL2005 Mgt Studio - script DROP before CREATE?

Author
11 Nov 2005 1:26 PM
Dave
In SS2000 you could set up the scripting options to check for existence and
then issue a DROP statement for before a CREATE statement.

How is this accomplished in Mgt Studio for 2005?

Author
11 Nov 2005 1:40 PM
Andrew J. Kelly
It isn't.  They goofed on that one and we will most likely have to wait
until SP1 for that.


--
Andrew J. Kelly  SQL MVP


Show quote
"Dave" <D***@discussions.microsoft.com> wrote in message
news:2C4BA869-8F20-43B9-9071-BC5E2401D854@microsoft.com...
> In SS2000 you could set up the scripting options to check for existence
> and
> then issue a DROP statement for before a CREATE statement.
>
> How is this accomplished in Mgt Studio for 2005?
Author
11 Nov 2005 2:07 PM
Dave
Argghh!!

Thanks for the answer. Was this missing in the betas or CTPs?

Show quote
"Andrew J. Kelly" wrote:

> It isn't.  They goofed on that one and we will most likely have to wait
> until SP1 for that.
>
>
> --
> Andrew J. Kelly  SQL MVP
>
>
> "Dave" <D***@discussions.microsoft.com> wrote in message
> news:2C4BA869-8F20-43B9-9071-BC5E2401D854@microsoft.com...
> > In SS2000 you could set up the scripting options to check for existence
> > and
> > then issue a DROP statement for before a CREATE statement.
> >
> > How is this accomplished in Mgt Studio for 2005?
>
>
>
Author
11 Nov 2005 2:35 PM
Andrew J. Kelly
Yes, but somehow got thru the cracks. You are not alone on this one<g>.

--
Andrew J. Kelly  SQL MVP


Show quote
"Dave" <D***@discussions.microsoft.com> wrote in message
news:E377B300-01A6-4587-9555-38AABBBE1472@microsoft.com...
> Argghh!!
>
> Thanks for the answer. Was this missing in the betas or CTPs?
>
> "Andrew J. Kelly" wrote:
>
>> It isn't.  They goofed on that one and we will most likely have to wait
>> until SP1 for that.
>>
>>
>> --
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "Dave" <D***@discussions.microsoft.com> wrote in message
>> news:2C4BA869-8F20-43B9-9071-BC5E2401D854@microsoft.com...
>> > In SS2000 you could set up the scripting options to check for existence
>> > and
>> > then issue a DROP statement for before a CREATE statement.
>> >
>> > How is this accomplished in Mgt Studio for 2005?
>>
>>
>>

AddThis Social Bookmark Button