February, 2009

Environment : è Windows Server 2003 SP2 x64 è SQL Server 2005 Standard Edition SP2 x86 Build 9.00.3215 (SP2 with Cumulative Update 5) Objective : è To install SP3 for SQL Server 2005. Problem : è SP3 failed to install...

While taking backups for SQL Server databases onto a mapped drive you might get the following error: " The system cannot find the path specified." This is because a network share that you map using a local drive letter will not be visible to a SQL...

As mentioned in my previous posts if the sql server fails to come online we need to start troubleshooting by looking at the sql server error log. So we checked the sql server error log and  found that sql server was started successfully and there...

The objective of this article is to help understand and create a CLR function to be executed as an SP in SQL Server. This with reference to the blog: http://blogs.msdn.com/sqlsecurity/archive/2008/01/10/xp-cmdshell.aspx for using CLR function as a work...

Consider the following the scenario Scenario : SQL Server 2000 Instance             : Collation A We perform a upgrade from SQL Server 2000 to SQL Server 2005 changing the collation. After successful...

Consider the following scenario where you upgraded a database from sql server 2000 to sql server 2005 instance and changed the compatibility of the database to 90 and now you wish to drop the Full Text catalog which was originally created in the sql server...

While applying Cumulative Update 10 on a sql server 2005 SP2, the update may fail to install after 80% setup was completed with the following error message. ERROR MESSAGE =========== [Microsoft][SQL Native Client][SQL Server]CREATE DATABASE failed...

Many times we need to reinstall a sql server instance due to number of reason. Whenever you reinstall the sql server instance the success of the installation of the new sql server instance primarily depends on the whether the previous uninstall of...