December, 2009

Error messages: The log reader fails with the following error message: ============================================== The process could not execute 'sp_MSpub_adjust_identity' on 'PR2K8\YUKON'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help...

When we try to install SQL Server 2005 on a Windows XP with Service pack 3, we get the following error : --------------------------- setup.exe - Application Error --------------------------- The application failed to initialize properly (0xc0150004...

While trying to view the SQL Error logs in SQL Server Management Studio or using xp_readerrorlogs it internally executes sp_enumerrorlogs. And sp_enumerrorlogs – tries to execute the below command: serverproperty('ServerName') - The command was...

In this blog, I will be sharing a unique instance of data capturing and analysis using SQL Activity monitor ,SQL DMV’s and also their correlation. We usually tend to see Activity monitor for a quick understanding of SQL health and resource consumption...

Very often we use UNC location while taking backup of SQL or Analysis Services Database or try to upload data in SQL Tables using bulk load command where text or csv file located in File Server so we access it by giving UNC. Sometimes File Server Machine...

With Analysis Services 2005 (2008) you can collect traces without using gui this feature is known as Server Side Tracing. In this article we’ll talk about how to achieve Server Side Tracing. How to create a Server Side Trace Open SQL Server profiler connect...

Connectivity fails while executing queries against SQL through VBA code ************************************************************* When we execute queries against the SQL through VBA code generates the below error - and fails to complete the code execution...

The setup of the Microsoft products is considered to be extremely easy. Mostly one need to click on few "Next" buttons and the setup is done. But when the setup fails, it can be extremely interesting. I encountered one such interesting setup failure....