SQL Server Performance

customize my script

Discussion in 'Analysis Services/Data Warehousing' started by jeet, Jul 20, 2005.

  1. jeet New Member

    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
  2. FrankKalis Moderator

    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)

Share This Page