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)
