How to change server collation in Microsoft store operation Administrative

(0) Share

Report

Posted on by Umar Khitab

750

Dear's All.

I want to change the server collation in Store Operation Administrative. Can any body help me that how can i change the server collation after that my Databas collation and server collation will b same and there will be no conflict error is coming.

Please Help me as early as possible.

Thanks

Umar Khitab

*This post is locked for comments

All responses (2)

Answers (0)

Umar Khitab 750 on at

Like (0)

Report

Re: Re: How to change server collation in Microsoft store operation Administrative

Thank you very much to give me such a good answer.

I can rebuild the master database and during rebuilding of master database I can change my server colation.

Thanks again.

Umar Khiab
Community Member on at

Like (0)

Report
Re: How to change server collation in Microsoft store operation Administrative

Hi, I find this from Microsoft
"--------------------------------------------------------------------------------------------------------------
Changing the default collation for an instance of SQL Server can be a complex operation and involves the following steps:

Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them.

Export all your data using a tool such as the bcp Utility. For more information, see Importing and Exporting Bulk Data.

Drop all the user databases.

Rebuild the master database specifying the new collation in the SQLCOLLATION property of the setup command. For example:

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName
/SQLSYSADMINACCOUNTS=accounts /[ SAPWD= StrongPassword ]
/SQLCOLLATION=CollationName
For more information, see Rebuilding System Databases.

Create all the databases and all the objects in them.

Import all your data.
" --------------------------------------------------------------------------------------

thank you
Mohammed El Qadi
http://www.fact.fm/viewforum.php?f=30