Clever Geek Handbook

Sql Server Management - is it possible to avoid sorting sorting?

I have databases with different collation. I want to be able to script to dump tables from one database and create them in another. However, when I script prints out the tables, it turns on sorting in the column definitions.

Is there a way to exclude sorts from scripts to create generated tables?

0


source to share


3 answers


Tools -> Options

In the "Scripts" section (in the "Table / View" section)



Set Enable Sorting to False!

+2


source


Pretty lame - but do a search and replace with the script after it has been generated?



0


source


What version of SSMS are you using? Full Edition or Express Edition?

You will need to apply at least SP2 for 2005 to get the scripting preferences in the Tools → Options menu.

This does not need to be applied to database servers, and it can only be applied to client tools on the administrator workstation if needed.

0


source






More articles:


All Articles