SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

7/30/2007

hotfix or SP stops unexpectedly on SQL Server 2005

SQL Server 2005 Cluster which has many instances or contain many nodes may gives you error while upgrading it with hotfix or service pack; the simple procedure to update hotfix and sp has been given by Microsoft, read more on KB 9364...

Failed to connecto to SSIS

Sometimes we receive "SSMS failed to connect to SSIS on client machine", Microsoft has released KB 940232 for the workarou...

Timeout occured while running dbcc freeproccache/alter database/sp_configure/sp_detace_db

Some of us might have face timeout when we run DBCC FREEPROCCACHE, Alter Database, Restore Database, SP_configure or sp_detach_db ; Microsoft has released KB 925419 which has workaround for the proble...

7/16/2007

Disaster Recovery Articles on MS SQL Server

Here are some good Disaster Recovery articles on MS SQL Serverhttp://support.microsoft.com/kb/3077...