I've seen a couple issues where SQL 2005 SP3 setup failed with below error for database engine and tools. Customer had installed SQL 2005 and SP2 from network location (using mapped drive) and is concerned that problem is due to install being a network...

We have configured Merge replication in SQL Server and we have the replicated constraint's name on the subscriber is different from the constraints on the publisher. It is possible that we will have the constraints on the subscriber even after they have...

Most of the Customers using sql server 2000,2005 and 2008 have this doubt in their mind when using parallelism in sql server. Why Do I see more threads per SPID in sysprocesses than MAXDOP? The above question is being addressed in the following...

Recently we encountered a case where in the Log Reader Agent fails to run and the following error is reported in the Replication Monitor Error messages: The process could not execute 'sp_replcmds' on 'TXDAL01410'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011...

Recently we have encountered a case where Merge Agent was failing to apply a transaction at the subscriber with the following error Error Message ============== The change for the row with article nickname 2336003 (test), rowguidcol {D46DF7AF...

We have observed a number of cases where the installation of the SQL server 2005 instance on the cluster fails with the following unexpected Failure Error Message while performing SCC checks. ERROR MESSAGE: ==================== There is unexpected...

In the daily life of an SQL server DBA, we get numerous questions regarding the auditing possibilities for the different actions being performed on the database by different users. So it always comes handy if we have some kind of code ready to start the...

When we create the database using the Management Studio GUI, the size of the new database is the same as the Model Database and also the properties of the new database such as MAXFILESIZE, FILEGROWTH is inherited from the model database. However...

We have observed a number of cases where the installation of SP2 succeeds on Active Node while it may fail on the passive node while installing SP2 on the clustered instance of SQL server 2005. In order to find the cause of the failure on passive node...

We have observed a number of case where we use sql server replication on a clustered instance of sql server and when we try to failover from Node 1 to Node 2 the Log Reader agent may fail to start with the following error Error messages: The...

It is not recommended that you use Outlook 2002 or Outlook 2003 together with SQL Mail and with Internet mail servers that use SMTP or POP3. More info on this is available at http://support.microsoft.com/?id=897349 . Below is a practical workaround if...

Three Servers (Top, middle and Bottom) Data will flow from Top to the Bottom Server. Top to Middle Server (one way Replication) and Middle to Last Server (two ways Replication). ================================================= ----> Top Server...

At times, when you try to open the tables within a Database in SQL Server 2000 Enterprise Manager, you may see below error(s): 1. Error while trying to explore table from Enterprise Manager: --------------------------------------------------...

Sometimes the query performance degrades due to the out of sync stats on the tables in the database. But how do we know it and how we do reach at the conclusion that the stats are the cause of the performance degradation. This is pretty well known but...

Sometime back I got to work on an interesting issue related to the login on the SQL Server replication. The Active Directory group we used to grant access to a snapshot publication does not show up in the Publication access list anymore when viewing...

In order to change the Virtual IP of the sql server 2000 clustered instance we need to follow the following KB article http://support.microsoft.com/kb/244980 However If we try to change the Virtual IP by mapping the Virtual Server Name of the sql...

/*** Note: Kindly follow the Instruction in each step ***/ /*** If you are using SQL Server 2008 Management Studio, Ctrl-Shift-M might not work. In that case go to “Query” menu and click on “Specify Values for Template Parameters” ***/ 1) Logon...

We have observed a few cases now where sql server has started performing slow after changing the Cost Threshold Of Parallelism server option of the sql server. Ironically in such cases we observe that sql server is performing slow even when there...

You are able to submit the data in the table using the application like InfoPath 2007 but when you go ahead and add the table in the Merge Replication Publication, the insert into the table using the InfoPath form starts to fail. This issue occurs when...

We get the below error message when distribution agent tries to sync, Error: 14151, Severity: 18, State: 1. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. ...

Accessing Linked server using Synonym results in an error after we rebuild Indexes on the target server in SQL Server 2005. The Error Message is like below, Msg 7359, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "Domain...

Setup.exe can be patched dynamically on the fly One of the drawbacks of the sql server 2005 setup was that if there was any bug detected in the code of the setup.exe , the patching of the setup.exe was difficult and at times next to impossible. ...

With Service Broker, internal or external processes can send and receive guaranteed, asynchronous messages by using extensions to Transact-SQL Data Manipulation Language (DML). Messages can be sent to a queue in the same database as the sender, to another...

Salient Features of Sql Server 2008 (Katmai) Setup Minimize the MSI code for setup and use MSI code for what it does the best. In Sql 2005 entire setup process was coded using MSI code which uses the Windows Installer code and was found to be root cause...

In order to install, upgrade, uninstall, and patch the sql server 2008 instance on the system we need to call the setup.exe from the installation media. The setup.exe is an unmanaged code which checks the basic pre-requisites to launch the actual Setup...