Wednesday, March 7, 2012

drop and create in the same script in management studio

In SQL 2000, we could generate the drop and create statements for an object
in the same script. I have not been able to do this in management studio. Am
I missing something?
No you aren't missing something the tool is<g>. It was somehow left out but
I suspect we will see it in the next service pack. As of now you can only
choose one or the other but not both.
Andrew J. Kelly SQL MVP
"Quinn" <dellsql@.newsgroups.nospam> wrote in message
news:u4l9AgqLGHA.3104@.TK2MSFTNGP11.phx.gbl...
> In SQL 2000, we could generate the drop and create statements for an
> object in the same script. I have not been able to do this in management
> studio. Am I missing something?
>
|||Quinn wrote:
> In SQL 2000, we could generate the drop and create statements for an
> object in the same script. I have not been able to do this in
> management studio. Am I missing something?
Seems to be a bug as the docs indicate you can do a drop, create, or
drop and create.
David Gugick - SQL Server MVP
Quest Software

No comments:

Post a Comment