February, 2010

When you install SQL Server 2005 Management Studio on Windows Server 2008, you might encounter the following error Error 1935. An error occurred during the installation of assembly 'Microsoft.MSXML,Version="8.0.0.0",Culture="neutral",PublicKeyToken...

Well, this is often a tricky situation, where you are running into Virtual Address Fragmentation and getting OOM (out-of-memory) errors in your SQL Server. More often than not there is confusion between physical memory pressure vs. virtual memory pressure...

I recently replied on a MSDN post regarding an issue where the user had created a DDL Trigger for ATER_LOGIN event but only wanted to be notified about password change events. I can understand the amount of frustration that can occur when you have mostly...

Today I am going to talk about FTS IFilters, its security considerations and some basics on troubleshooting issues with PDF Filters. Read on and be enlightened… What is a Word-Breaker? It is a component within the FTEngine that’s responsible to...

When we run the service pack 4 setup for SQL 2000 MSDE we noticed that when we launch the service pack setup the setup.exe is launched (shows up in the task manager) but exits immediately without warning! Setup in SQL Desktop Engine (MSDE), rolls back...

Suppose you encounter the following scenario:- SQL Server 2005 login ‘Test2’ is a member of only Public server role and is not mapped as a User in any Database, nor does it own any Schema. We can verify that the login 'Test2' is not mapped as a...

This post describes how to strip off unwanted quotation marks around the character strings in the data file. Let’s assume that you have a text file which has the following data and you want to import the data into a SQL Server database table. “ ABC ”...