BEHAVIOR/SYMPTOMS: During a BCP operation in SQL 2005, a column with less precision gets truncation errors.BCP in SQL Server 2000 didn’t report truncation errors which could affect business logic in applications where precision data up to a certain decimal...

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

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

It's has been couple of years for me working on SQL Server and I keep coming across various SQL Server misconceptions (or say a DBA Myth). In this specific post I’ll demystify a common DBA myth around log-shipping: " In a log shipping setup, to have...

Problem: SQL Server Agent cannot start because the instance of the Server Instance is not the expected Instance The SQL Server Agent may fail to start after a restart of the SQL Services. You may see this issue when you have multiple SQL Server...

Consider a scenario where we have set up a transactional replication between two servers and you want to MOVE the publication database and Distribution database to a different location.  The procedure for moving the system database ‘Distribution...

Thanks for overwhelming response of part 1 of the series. As a part of this series, we have created a Domain Controller (Win2k8MyDC). Let’s go ahead and follow the steps below to add two more machines into my domain (blakhani.com). For this you need two...

Here is a scenario where you might end up receiving a Fatal Error while installing SQL 2005 on Windows 2008 environments. Below is the snippet from the Setup logs: Summary Log: ========== OS Version : Server 4.0, Enterprise Edition Service...

Symptoms: Application Popup Error: =========================== The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <Computer Name> Error:2147749896 (0x80041008). [Environment]...

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

In some situations you would like to use WITH NOWAIT option in SQL Server RAISERROR statement, but somehow you usually have to wait until the procedure is complete before seeing messages. You search through MSDN links but end up reading several different...

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

The problem is that we have a Named instance of SQL Server 2005 in a 2 node cluster. While trying to bring the SQL Services online we get these error messages in the Application Event Log. Application Event Log: Event Type: Error Event Source...

You encounter report server connection failure with below error message. Below is one of the instance which I witnessed while connecting through SSMS, it fails while using the server name (SERVERNAMEABC) Error: ===== TITLE: Connect to Server --...

Symptoms When you open SQL Server profiler, and try to start a new  trace (or when try to open an existing trace ), you get the error " Unable to read trace definition file Microsoft SQL Server TraceDefinition 9.0.1187.xml. Click OK to retreive...

ISSUE: I’m trying to restore a database backup from SSSMS-UI, however it fails in an initial stage with below error TITLE: Microsoft SQL Server Management Studio ------------------------------ Specified cast is not valid. (SqlManagerUI) ----...

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

SYMPTOMS: ========== Installation for SQL Server 2008 Management studio fails with the MSI error code: 0x5EBE5729 //////////////From Summary.txt//////////////////// Feature: Management Tools - Complete Status: Failed: see logs for details...

What does the Scan Count output in the SET STATISTICS IO output actually mean? I have seen multiple posts on the web regarding confusions and theories around this. As per Books Online , Scan Count is: Number of index or table scans performed. ...

PROBLEM: When you open SQL Server 2008 configuration manager you do not see the following options : Scenario 1 (64 bit options): 1) SQL Native Client 10.0 configuration 2) SQL Server Network configuration Scenario 2 (32 bit...

PROBLEM DESCRIPTION =================== While trying to migrate the database from sql2008 enterprise to standard you get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed...

Good morning Folks! Today I will take you through a setup issue that many of you might have run into when trying to install SQL Server 2005 (especially on a cluster). I’ve tried to list down all possible solutions to the following errors one faces while...

INF: SQL Security - Restricting access to public on server/database objects, its implications and ownership chains There are times when you need to harden the security of your SQL Server and prevent the public/guest users from having access to certain...

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

As most of the times we do it in a simple way descirbed below. but when we try to do the same through stored procedure it fails. Just for information regarding impersonation:- http://msdn.microsoft.com/en-us/library/ms188354(SQL.90).aspx Solution...