Security! This is the word comes in mind of every concerned person when it come...
This post will show you how to change the collation settings in MS SQL Server for specific database...
In this post I will show you how you can resolve collation conflict error...
In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...
Generally, we create views and stored procedures (proc here after) ...
Sometimes business demands or change in naming convention for servers lead to situation where one should change / rename the Server running MS SQL Server, it would not that panic renaming SQL Server as you have sp_dropserver and sp_addserver to help you, but what if this SQL Server box have reporting server too; well microsoft has workaround for it refer - http://technet.microsoft.com/en-us/library/ms345235.aspx
