Microsoft SQL Server Tips & Tricks
Tips and Tricks for the SQL Server Enthusiast
SQL Server 2005 setup fails on windows 2008 due to corrupt VC++ component
Here is a scenario where you might end up receiving a Fatal Error while installing SQL 2005 on...
Author: AmruthaVarshiniJ Date: 04/22/2010
sp_help_log_shipping_monitor may return the following error after role reversal in SQL 2000/2005 : Violation of PRIMARY KEY constraint . Cannot insert duplicate key in object 'dbo.#log_shipping_monitor'
Problem Description =============== · After role reversal in a log shipping setup, the stored...
Author: AmruthaVarshiniJ Date: 04/22/2010
How to un-cluster SQL Server 2005 Cluster
(How to uninstall SQL Server 2005 Cluster / How to break SQL Server 2005 Cluster ) There will be...
Author: AmruthaVarshiniJ Date: 04/22/2010
DB Maintenance: Rebuild Index Task always fails on OperationsManagerDW [SCOM database]
Problem Description ======================================= We encountered a situation where we were...
Author: AmruthaVarshiniJ Date: 04/19/2010
Unable to connect to SQL Server immediately after applying Service Pack /Cumulative updates.
Symptoms. ======== You are unable to connect to SQL Server immediately after applying Service Pack...
Author: AmruthaVarshiniJ Date: 04/14/2010
SQL Server 2005 Setup Failure on Cluster Due to Corrupted User Profile
Recently I came across an issue wherein you are installing SQL Server 2005 on an n-node Windows...
Author: AmruthaVarshiniJ Date: 04/06/2010
Unable to create a login in SQL Server 2005 and we get the following error The server principal '[$]' already exists.
SYMPTOM ======= · When you try to create a login using the command "Create login...
Author: AmruthaVarshiniJ Date: 04/06/2010
Step by Step Guide to Setup a Dedicated SQL Database Mirroring(DBM on dedicated Nic card)
One of the Best practice for database mirroring(DBM) is to setup DBM on dedicated NIC card\Network...
Author: AmruthaVarshiniJ Date: 03/31/2010
Unable to connect to SQL Server 2008 instance after applying SP1
Problem Description =============== Not able to connect to SQL Server 2008 instance after applying...
Author: AmruthaVarshiniJ Date: 03/31/2010
SSAS Profiler Scheduler
I have been asked by many customers and seen in many social sites, people were asking about the...
Author: AmruthaVarshiniJ Date: 03/31/2010
SQL Server 2008 Setup fails to Install with Error 1402
SQL Server 2008 setup may fail with the following error even though you are running the setup as...
Author: AmruthaVarshiniJ Date: 03/30/2010
How to install Clustered SQL Server 2008 on Windows 2008 Cluster using Hyper-V (Guest Clustering) Part – 1
We are starting a series for DBAs and others who want to create a SQL Cluster on Hyper-V. This...
Author: AmruthaVarshiniJ Date: 03/29/2010
Unable to connect to Enterprise Manager in SQL Server 2000
Problem Description =============== Encountered the following error message when tried to connect to...
Author: AmruthaVarshiniJ Date: 03/29/2010
Unable to connect to SQL Server 2005 from Backupexec application
Problem Description: =============== While connecting to SQL Server 2005 Express instance through...
Author: AmruthaVarshiniJ Date: 03/29/2010
SQL Server encounters memory pressure and generate 701 Error due to incorrect configuration of Service Broker
Here is one of the rare scenario on SQL Server memory issue (701 error) caused due service broker...
Author: Nikesh Mhatre Date: 03/25/2010
Installation for SQL Server 2008 Management studio fails with the MSI error code: 0x5EBE5729
SYMPTOMS: ========== Installation for SQL Server 2008 Management studio fails with the MSI error...
Author: AmruthaVarshiniJ Date: 03/24/2010
SQL Server 2008 Slipstream Setup on Windows Cluster May Fail With “The system cannot find the path specified”
Recently I encountered an issue where the in-place upgrade of the SQL Server 2005 to SQL Server 2008...
Author: AmruthaVarshiniJ Date: 03/23/2010
Configuring Database Mail failing with error - @no_credential_change is not a parameter for procedure sysmail_update_account_sp. (Microsoft SQL Server, Error: 8145)
Recently we have encountered the following error message while configuring Database Mail in SQL...
Author: AmruthaVarshiniJ Date: 03/23/2010
Slipstreaming SP1 with SQL Server 2008 Express edition advanced services is not possible
I had a situation where I needed to install SQL Server 2008 Express edition with management studio...
Author: AmruthaVarshiniJ Date: 03/19/2010
Database Mail failing with “The service queue "ExternalMailQueue" is currently disabled.” message
Some of you may experience problems while using Database Mail on SQL Server 2005 or SQL Server 2008...
Author: AmruthaVarshiniJ Date: 03/18/2010
SQL Server 2008 Configuration Manager on a 64 bit machine does not display Network configuration & Native Client configuration options
PROBLEM: When you open SQL Server 2008 configuration manager you do not see the following options :...
Author: AmruthaVarshiniJ Date: 03/16/2010
How to use -UseInProcLoader in Distribution agent and get it working
When we use the option of -UseInProcLoader in Distribution agent profile, the distribution agent...
Author: AmruthaVarshiniJ Date: 03/03/2010
BCP in SQL server 2005 does not truncate a column
BEHAVIOR/SYMPTOMS:During a BCP operation in SQL 2005, a column with less precision gets truncation...
Author: AmruthaVarshiniJ Date: 03/02/2010
SQL Server 2005 Management Studio setup - An error occurred during the installation of assembly Microsoft.MSXML (HRESULT: 0x80070003)
When you install SQL Server 2005 Management Studio on Windows Server 2008, you might encounter the...
Author: AmruthaVarshiniJ Date: 02/17/2010
How to find who is using / eating up the Virtual Address Space on your SQL Server
Well, this is often a tricky situation, where you are running into Virtual Address Fragmentation and...
Author: AmruthaVarshiniJ Date: 02/16/2010
EVENTDATA function behavior for DLL Triggers related to Logins
I recently replied on a MSDN post regarding an issue where the user had created a DDL Trigger for...
Author: AmruthaVarshiniJ Date: 02/11/2010
SQL FTS IFilters, its security implications and troubleshooting PDF Filter issues
Today I am going to talk about FTS IFilters, its security considerations and some basics on...
Author: AmruthaVarshiniJ Date: 02/11/2010
Installation/Upgrading of SP4 on MSDE fails with 'Error: 0x800401F0'
When we run the service pack 4 setup for SQL 2000 MSDE we noticed that when we launch the service...
Author: AmruthaVarshiniJ Date: 02/11/2010
Drop failed for Login since it has granted one or more permission(s)
Suppose you encounter the following scenario:- SQL Server 2005 login ‘Test2’ is a member of only...
Author: AmruthaVarshiniJ Date: 02/09/2010
Error messages and the solutions related to “distributor_admin” login
Error messages: The log reader fails with the following error message:...
Author: sequelguy Date: 12/21/2009
Unable to install SQL Server 2005 on a Windows XP machine
When we try to install SQL Server 2005 on a Windows XP with Service pack 3, we get the following...
Author: sequelguy Date: 12/20/2009
Unable to view Error logs in SQL Server Management Studio on a cluster
While trying to view the SQL Error logs in SQL Server Management Studio or using xp_readerrorlogs it...
Author: Nikesh Mhatre Date: 12/17/2009
Data Capturing and Analysis using SQL Server 2008 Activity Monitor and SQL DMV’s
In this blog, I will be sharing a unique instance of data capturing and analysis using SQL Activity...
Author: Nikesh Mhatre Date: 12/17/2009
Why do we need SPN for File Server (NAS / RAS / File Share System) DNS Alias (Cname)
Very often we use UNC location while taking backup of SQL or Analysis Services Database or try to...
Author: sequelguy Date: 12/15/2009
SQL 2005 (SQL 2008) Analysis Services Server Side Tracing
With Analysis Services 2005 (2008) you can collect traces without using gui this feature is known as...
Author: sequelguy Date: 12/15/2009
Connectivity fails while executing queries against SQL through VBA code
Connectivity fails while executing queries against SQL through VBA code...
Author: Nikesh Mhatre Date: 12/10/2009
Installation of Service Pack 3 for Reporting Services 2005 fails on a cluster with an error code 2228
The setup of the Microsoft products is considered to be extremely easy. Mostly one need to click on...
Author: sequelguy Date: 12/01/2009
Installation of Non-MS Fonts cause .NET errors during SQL server 2005 setup
Setup is ideally supposed to be an easy process, but more often than not we are fraught with a...
Author: AmruthaVarshiniJ Date: 11/11/2009
Issues with SQL Server Login Failures and dependency on Windows Password Policy Check
Good afternoon techies! I recently worked with some customers on SQL Server 2005 login failure...
Author: AmruthaVarshiniJ Date: 11/11/2009
On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan MIGHT fail with: “The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired)”
On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan fails with below...
Author: Nikesh Mhatre Date: 11/09/2009
[Executing BCP fails with SQLState = 37000, NativeError = 4891. Error = [Microsoft]ODBC SQL Server Driver][SQL Server]Insert bulk failed due to a schema change of the target table
BCP is a very commonly used operation and sometime very critical and failure could cause loss of...
Author: Parikshit Savjani Date: 11/04/2009
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)
You encounter report server connection failure with below error message. Below is one of the...
Author: Parikshit Savjani Date: 11/04/2009
SP_COLUMNS take longer in SQL Server 2005 SP3 compared to SQL Server 2000
Recently we encountered a case wherein one of the user application which internally calls sp_column...
Author: Parikshit Savjani Date: 10/30/2009
Unable to open the configuration manager in SQL server 2005
Problem Description in our scenario: ============================ We have a SQL server 2005...
Author: Parikshit Savjani Date: 10/27/2009