June, 2009

Environment SQL Server 2005 AND SQL Server 2008. The same command works fine in SQL SERVER 2000. Steps to Repro create proc p1 as declare @typ sysname select @typ = name from (select 'ntext' as name) as t <== FMTONLY mode does not execute this statement...

During our course of troubleshooting queries taking long time for compilation, co-incidentally we found that SELECT * FROM SYSINDEXES was giving us an exception. We were getting the following error in Management Studio whenever querying SYSINDEXES Msg...

Consider a scenario where SQL 2000 has been uninstalled and Hotfixes are still visible. In my case it was hotfix 2050 and 2273. One will find the hotfix components visible in the ADD\REMOVE program. In that scenario attempts of removing the hotfixes are...

Consider a scenario where an upgrade from SQL 2005 to SQL 2008 fails with the following messages while installing Setup Support Files. ******************************************************** TITLE: SQL Server Setup failure. -------------...

We are unable to start SQL Server Agent. It was giving the following error when we were trying to start it from the services console The SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically...

Problem Description: ========================= The owner of the job is a Windows login in SQL and cannot modify the job which he owns. This issue will occur if the Windows login added to SQL and the case of the login does not match. Steps to Repro: =...

  Problem: You have a VB script to take full database backup and transaction log backup using SQL DMO but when the job is executed it takes full database backup always even if in the code it is specified to take transaction log backup. The part where...

When you configure a merge replication with web synchronization using FTP over internet, you might run into an issue when you run the merge agent. Assume that we have configured the merge replication with the above specifications and have run the...

Problem description: The BCP command with code page 65001 fails when both SQL Server 2000 and SQL Server 2005 tools are present on the server. Cause: This issues occurs because when both SQL Server 2000 and SQL Server 2005 tools are present on...

Problem Description in our scenario: ==================================== The Instance which we needed to upgrade did not appear in the " Instance to upgrade” drop down box while doing an upgrade from the SQL server 2005 to 2008. Cause of the...

Issue / Symptoms : Trying to install SQL Server Express edition. During the installation wizard, we see couple of initial screens and then without giving any user input screen to provide instance name etc, the setup advances to the last screen where it...

When you try to debug a stored procedure on the server from the client machine, the debugger just runs through the code and does not stop at any executable statement or break-point. The debugger however works locally both at the client and server. No...

This blog is targeted to Merge replication. Note: Please note the sp_showpendingchanges is only an estimate and not the actual number of changes so it cannot be used for ensuring consistency. It is based on changes known as per local metadata and doesn...

There can be many reasons for the size of Transaction Log growing large for a sql server database such as waiting on checkpoint, backups in Full recovery model, active long running transaction. The simplest and the smartest way to determine the...

Consider a scenario where on an Active Passive Cluster, while uninstalling an instance of sql2000 patched with Service Pack 4, we see the following error after you click next on the screen where we enter the Virtual Server name. 'The specified virtual...