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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy