Creating SQL Script

  • How can I script table from my database without 'CREATE STATISTICS ', 'COLLATE' and 'ON GROUP' from EM (2000)? I do need though indexes and all constraints to be scripted.


  • Dont you think you have many options from EM. Take a look at script tab under options in Query Analyzer. Another way would be to use DMO and set the options yourself.


  • I couldn't find any corresponding option in EM that's why I asked for help. When you use Query Analyzer you can script only one table and I needed to script all tables in database.

    Anyway I found an option in SQLDMO for Script2Type = SQLDMOScript2_NoWhatIfIndexes. It does exactly what I wanted.


Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply