Query Analyzer "Script to.." Function and alter table

microsoft.public.sqlserver.tools

8 Dec 2005 3:00 PM

hromankokap

I'm trying to figure out why Query Analyzer for SQL 2000 SP4 disables (greys
out) the Alter option in the "Script Object to..." command in the object
browser for user tables even when you are connected as a db admin (Windows)
or sa (SQL server). It would be nice to be able to generate Alter table
scripts from the object browser with a couple of mouse clicks just like we
can generate create table scripts.

Note, I'm not asking how to write an Alter table script -- we can do that,
in fact we have a stored procedure to write out our Alter table template.
I'm just wondering why this behaviour occurs in Query Analyzer -- is it a
bug, a design feature, a permissions issue, etc?

Thanks for any help..
Howard Romanko
Senior Developer
Kingdom Autoparts

9 Dec 2005 2:04 PM

denis.gobo

Seems like a feature to me, since it works for procs and UDF's

http://sqlservercode.blogspot.com/