SQL server setup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL server setup

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-25 : 10:33:17

Mohammad writes "Hi,

I am new to Microsoft SQL Server. I am running Sql server 2000 standard edition SP4. Now for one of my Software i need to change the default settings for SQL server. I need to change the followings:

Character set: 437 U.S English

Sort Order:1252 ISO Character Set, 52 nocase_iso Dictionary order, case-insensitive

Unicode Collation: 1033 General Unicode

Unicode Style: Case-Insensitive

Now i don't know how to check the above settings on the server. I need to know whether they are already set up as above if not i need to change them to the above defaults.

Can you please help with that.

Thanks very much."

dewacorp.alliances

452 Posts

Posted - 2006-08-25 : 11:25:40

Hi there

All collation databases will follow the configuration that is defined when you install SQL. Normally, I look by running:

sp_helpdb 'master'
GO

and look at the status (,Collation="")

To translate that info, you need to check out this list: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_5ell.asp

Hope this help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources