Issues associated with Scripting options:
Query Analyzer allowed the following generic options that have been removed from SSMS:
Identifier Delimiter : None, Version dependent, [] or ""
Do not script the collation.
Generate Transact-SQL to remove referenced component. Script tests for existence prior to attempt to remove component.
Do not include 'ON <filegroup>' clause directing filegroup use.
and table Scripting Options:
Qualify object name by its owner.
Do not include definition of identity property, seed, and increment.
Generate SET ANSI_PADDING ON and SET ANSI_PADDING OFF statements before CREATE TABLE statements.
Also Enterprise Manager Generate SQL Scripts tool had:
Files to Generate: Create one file or one file per object - Gone!
Create Drop object options - now it's one or the other.
As someone else said in another post - why have Microsoft removed useful functionality from the scripting options. It doesn't make sense - were these options over looked or was it a conscious decision.
When will these settings be reinstated - (and they need to be able to be set for the whole IDE as well as in the wizard (as per Query Analyzer:Tools|Options )
3rd Party Scripter for me until this is fixed - damn just need to find one now!
Alex
Hi Alex,
Some of these you will see addressed in SP2 -- Such as Create Drop options.
The others are in backlog of work items for the next general release of SQL Server.
A partial - (as in brief) explanation for why some disappeared had to do with 'forward' compatibility.
I will log your input in our Team Server database if you don't mind.
Thanks,
Terrence Nevins
SQL Server Program Manager
