|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL2005 Mgt Studio - script DROP before CREATE?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? It isn't. They goofed on that one and we will most likely have to wait
until SP1 for that. -- Show quoteAndrew 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? 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? > > > Yes, but somehow got thru the cracks. You are not alone on this one<g>.
-- Show quoteAndrew J. Kelly SQL MVP "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? >> >> >> |
|||||||||||||||||||||||