Well I’ve looked around in our blog and it pained me to see there were no posts on Full Text Search; an often misunderstood and under-utilized feature that SQL Server provides. Wait no more, here comes the first one (of many I hope) :) . In this post...

The SQL Server instances are independent and do not know each other. The method is to query the registry to find the instances. You can use the following Script to list all the installed sql server on the server using TSQL Solution ======...

Setup is always known to have a mind of its own; this blog is meant to demystify this process. We are specifically talking about SQL Server 2005 Setup on a cluster. It has been observed that the installation of the SQL server 2005 instance on the cluster...

Performance Monitor Counters has always been the "Bread and Butter" for System Engineers and Administrators alike. With each new version of Windows, Microsoft has always improved on and provided a "better than ever" performance monitors. With the performance...

We have seen a couple of cases, wherein we are unable to create maintenance plan or DBMail Fails after applying SP on SQL Server 2005 failover cluster instance running on Windows 2008 Cluster . Resource Database and other system databases may not be...

The Field Terminator specified in the BCP command changes to a different character than specified. This occurs when the bcp command is run in a batch file. The bcp works as expected when it’s run directly in the command prompt. In our example the section...

Have you ever wondered if there is a programmatic way to detect all the SQL server instances and services installed on a machine. Well, worry no more as the code below will do exactly that. There are 2 ways to go about this : Method 1 – For the Programmer...

There are quite a few blog posts out there to manage SQL Server 2005 services using the :\\.\root\Microsoft\SqlServer\ComputerManagement\ However, WMI Admin Provider is not pre-installed for SQL Server 2000. It needs to be installed separately using the...

The default database role members are not scripted when we use the "Generate Script Wizard" Cause ====== This is an issue with the Generate Script Wizard code . It considers the rolemember as a part of Permissions for the Role and hence scripts...

We have observed a number of cases where Sql Server resource fails to come online on Windows 2000 Cluster after applying a security patch. As mentioned in my previous posts whenever a sql server resource fails to come online we should start by checking...

When we use the Microsoft OLEDB provider for DB2 from the Feature Pack for Microsoft SQL Server 2005 in SSIS connection manager and set the component level or package level Transaction option to Required. The package execution fails with the error below...

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...

Due to any issue, you may want to rerun SQL 2000 SP4 upgrade. SQL 2000 Service Packs are cumulative. But when you re-run SP4 it only updates 7 Scripts those are new with SP4. This could be useful when SQL Server is already on SP3 and due to some reason...

We have seen several issues where installation of Service Pack/Hotfix/GDR/CU fails to install on one or more components of SQL Server 2005. In this blog , I have tried to include few troubleshooting tips and tricks for these kinds of installation failures...

While running your application on SQL CE v3.1 databases you may observe slowness in the performance of some of the queries especially those which involve querying the primary key. In Sql server databases when you create a Primary Key on a column of...

We have observed a number of issue now where in clustered instance of sql server 2005 fails to come online after performing changing on shared disk on a cluster. As mentioned in my previous posts if the sql server fails to come online we need to start...

We have observed a common issue which is faced by many of our  customers who export the result set from DTS package to excel worksheet. DTS package that exports results to an existing excel workbook appends the data  each time you run it. ...

Recently I encountered a case wherein clustered instance of sql server 2000 fails to come online on other node of a 2 Node Cluster.  Usually for such cases we need to start troubleshooting by checking the Error log of the sql server from the server...