Management Studio scripting options

9 Jan 2006 9:33 AM

Roman Mellenberger

Hi there,

Is there apossibility to set the options for script creation in SQL
Server 2005 Management Studio? I want to create a script with a drop
and create statement...

Regards
Roman

9 Jan 2006 2:34 PM

Andrew J. Kelly

No there isn't, all you can do is one or the other at the moment. It was
somehow missed from the released version. Lots of people have complained
and I am sure it will be back in witht he next sp.

--
Andrew J. Kelly SQL MVP

Show quote

"Roman Mellenberger" <roman.mellenber***@info-research.ch> wrote in message
news:v9b4s1hgm6pta45ukfoh9ucnjgs8ubdl6t@4ax.com...
> Hi there,
>
> Is there apossibility to set the options for script creation in SQL
> Server 2005 Management Studio? I want to create a script with a drop
> and create statement...
>
> Regards
> Roman

9 Jan 2006 4:24 PM

Tibor Karaszi

Perhaps Bill's utility can be useful?

http://www.sqlteam.com/item.asp?ItemID=23185

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

Show quote

"Roman Mellenberger" <roman.mellenber***@info-research.ch> wrote in message
news:v9b4s1hgm6pta45ukfoh9ucnjgs8ubdl6t@4ax.com...
> Hi there,
>
> Is there apossibility to set the options for script creation in SQL
> Server 2005 Management Studio? I want to create a script with a drop
> and create statement...
>
> Regards
> Roman