Wednesday, March 7, 2012

Collation is Missing when Scripting the Database

You might know that you are not allow to modify the Collation after creating a database.

So you use the scripting option for the database you will see that collation is missing in the script.

Following is the script database create with Danish_Norwegian_CI_AS collation.

image

However, you can see that collation is not mention in the above script.

If you want to script you need to explicitly mention the COLLATE as shown below.

image

No comments:

Post a Comment