Monday, March 26, 2012

How can I change Table Scripting Options defaults?

I'm using SQL Server 2000.
In Enterprise Manager, if I right-click a table then: All Tasks/ Generate
SQL Script /Options tab, there are Table Scripting Options. How can I
change the defaults?
For example, I would like "Script PRIMARY Keys, ..." to be checked by
default.
Thanx.This is not configurable, I'm afraid.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"msnews.microsoft.com" <vincent.rineer@.capbluecross.com> wrote in message
news:%23rMrMwbSFHA.3972@.TK2MSFTNGP14.phx.gbl...
> I'm using SQL Server 2000.
> In Enterprise Manager, if I right-click a table then: All Tasks/ Generate
> SQL Script /Options tab, there are Table Scripting Options. How can I
> change the defaults?
> For example, I would like "Script PRIMARY Keys, ..." to be checked by
> default.
> Thanx.
>

No comments:

Post a Comment