August 6, 2001 at 9:55 am
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.
Thanks
August 6, 2001 at 12:30 pm
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.
Andy
August 6, 2001 at 1:29 pm
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.
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply