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) ...
DBCC Checkdb gives error when you have finished restoring database with CONTINUE_AFTER_ERROR and you run DBCC CHECKDB. This will gives you an Error 8967 there may be inconsistancies in database or metadata which may lead to throw this error message....there is a workaround released by Microsoft Read workaround for Error 8967
