<div>
<div class="content wysiwyg-content">
I have 2 servers,<br />
When SQl Server was installed on them the collation was somehow set to be diiferent...<br />
As the production server uses the stuff developed in developement server ..when i try to copy stuff it gives collation error..<br />
Can i change the collation of the server by any means...?<br />
Is there a solution to fix the problem..?<br />
<br />
Thanks
</div>
</div>


I have 2 servers,
When SQl Server was installed on them the collation was somehow set to be diiferent...
As the production server uses the stuff developed in developement server ..when i try to copy stuff it gives collation error..
Can i change the collation of the server by any means...?
Is there a solution to fix the problem..?

Thanks

Different collation on Dev and prod Servers

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.