SQL Server Performance Forum – Threads Archive

customize my script

hi you, when i create sql script using the tool given in the system, it also includes the collation name in each create table statement. I dont want that statement. how do i customize the script generation that prevents the collation name in script. thank you jeet

The only way I know of right now, is to check the "Only script 7.0 compatible feature" on the Formatting tab. But that way you probably lose also some other 2000 features you want to be scripted. I’d script them to a single file and modify that with a text-editor . —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>