April, 2009

What is Deferred Update? If any column that is part of a unique constraint is updated, then SQL Server implements the update as a deferred update , which means as a pair of DELETE/INSERT operations. This deferred update causes replication to send a pair...

Consider a scenario when during the installation of SQL Reporting Services 2005 the option to choose Reporting Services is grayed out. The following warning displayed in SCC check 32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install...

Every once in a while I see VDI backups failing and questions being asked as to whether the sqlvdi.dll (which exposes the Interfaces to perform the backup) or the Software being used to take the backup is responsible or is it an issue with the Environment...

Right, ever heard or wondered about snapshot backups in SQL Server? You might have come across the Volume Shadow Service (VSS) backup option in SQL Server. In this post, I will try to explain what they are, how they work and what to check for when you...

Recently we encountered a case wherein distribution wizard was not appearing when we try to configure distribution server using sql server 2005 management studio. We do not see any error message in the errorlog or application event log while the cursor...

Consider the scenario where SQL server 2000 IA 64 setup on a SQL server cluster fails with the following error ERROR MESSAGE: Microsoft SQL Server Setup --------------------------- An error occurred while creating virtual server resources for clustering...

Problem: In place upgrade from SQL Server 2000 to  SQL Server 2005 may fail with the following error message though SQL Server 2000 instance may be at the build 8.0.2039 (SP4) Name: Microsoft SQL Server 2000 Reason: Your upgrade is blocked. For more...

We get the below error message when we try to restore from tape for large databases. ERROR MESSAGE: ============== TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact...

With Sql server 2000 and 2005 computed columns can be use to improve the performance of queries since without the computed columns, indexes cannot be used as explained in the following blog by one of our Escalation Engineer Jack Li. http://blogs...

Let’s start with a little background on how SQL Server logins and Database users actually work. A login (Windows/SQL authenticated) gives you the permissions to log onto a SQL Server instance. With the help of the login, an individual can access the databases...

When you backup your database in SQL Server 2000 using a maintenance plan, the information is logged into dbo.sysmaintplan_databases. You can query this table to see, which maintenance plan did the backup of which database, using this query – select...

In the simplest terms an application role is one which allows access to a database through an application. As simple as that may sound there are some clauses which make these quite an interesting feature. An application role is like a plain canvas...

Environment: SQL Server Enterprise Edition 2005 32 bit on Windows Server 2003 Enterprise SP1 Consider a scenario where you are installing SQL Server 2005 Servce Pack 2 on a clustered environment. Sometimes you will notice that the installation get...

Consider a scenario where one wants to change the Destination Object Owner schema of all  the articles in a publication using “ Set Properties of All Table Articles” from DBO to any other user defined schema. What you will find is  that under...

Few days back I worked on a case where the sql server SP2 setup was failing to install with an Error 29528 so I thought I should blog this article to address the cause of the failure and how can we resolve the issue. Problem Description: You may...