how to check the collation settings?

Hi Thanks for the quick response,
Can you tell me how to change the collation setting for a particular database?
bcoz after running that what I found is one user database is having a different collation setting than the rest.
And how to see in SQL Server 2005 that server is runnig on inbuit or domain account?

You need to ask a separate question for how to change.

Hi mariraju,
This was the error I got when I tried to change the collation settings.
will it wrk if I take the database into single user?
Msg 5030, Level 16, State 2, Line 1
The database could not be exclusively locked to perform the operation.
Msg 5072, Level 16, State 1, Line 1
ALTER DATABASE failed. The default collation of database 'mciw_sideB' cannot be set to SQL_Latin1_General_CP1250_CS_AS.

What does this error means?

This is a separate question. Close this one and ask a new one. I answered your original question.

Hi Chapmandew,
I made it a seperate quest.
Can u plz check it?

Sure. Close this one too.

Yes , Please use the single user(administrator) connection for the database and it works fine.

I have tried the same query for database with single user, which worked well for me

Please let me know

Good

thanks, but this was not a "B" answer, it was an A.

Hello again,

To put the database into single user mode, please try the following. After that, you should be able to run the rest of the commands easily.

ALTER DATABASE database_name  SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

Once the job is done, please put the database back into multi user mode.

ALTER DATABASE database_name  SET MULTI_USER
GO

I hope this solution works for you. Please do let me know.

Cheers

Hi,
I tried to change the instance collation with the cmd you given. It didn't worked out for me.
My case is a defaultinstance and server is running using inbuilt account.
Can you check it once if there is any error in that?