February 17, 2006 at 7:29 am
Is there a way to change the collation code at the Server Level for SQL 2005?
We have just installed SQL 2005 SE on a test box and it has been setup with the wrong collation code.
Any help would be appreciated.
Regards
Carl
February 20, 2006 at 8:00 am
This was removed by the editor as SPAM
February 20, 2006 at 9:54 am
You can find the details for changing collations in SQL Server Books Online:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/25b8a3da-a83b-411f-9bb9-ca684306b4d7.htm
or you can access Books Online from MSDN:
http://msdn2.microsoft.com/en-us/library/ms177439(SQL.90).aspx
Cheers,
Dan
February 21, 2006 at 3:23 am
The databases can now be configured with seperate collation settings independantly of the server.
ALTER DATABASE database_name COLLATE collation_name
COLLATE collation_name
Specifies the collation for the database. collation_name can be either a Windows collation name or a SQL collation name. If not specified, the database is assigned the collation of the instance of SQL Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply