How to change Collation settings for all databases

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 2005 Forums

SQL Server Administration (2005)

How to change Collation settings for all databases

Author

Topic

Shahbaz
Starting Member

1 Post

Posted - 2008-04-05 : 09:18:10

Dear All,

I am facing one problem when I am trying to create some stored procedures,
Msg 468, Level 16, State 9, Procedure SG_GET_USER_SECTOR_POSITION, Line 11
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure SG_GETRANKLIST, Line 4
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.
I need to change these collation settings, please help me how to change them.

thanks & regards,

Shahbaz.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-05 : 12:19:07

Show us structure of you SP so we can help
Like:
on A.column collate SQL_Latin1_General_CP1_CI_AS =B.column collate
SQL_Latin1_General_CP1_CI_AS

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-05 : 12:59:04

Collation setting are on Properties-options
of each databases.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-05 : 22:24:40

Changing db collation will not solve your problem, have to change column collation involved. Possible to post your sp? Some statements can specify collation.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources