Browse by Tags

We at SQL Server support team, continue to invest our time in writing tools and utilities which can aid you in troubleshooting SQL Server issues. SQL Server Backup Simulator is one such tool which will help you while troubleshooting issues in taking backup of SQL Server using 3 rd party utilities like...

A recent discussion on the #sqlhelp hashtag on Twitter got me researching into this issue. The error message was: 2010-10-19 02:56:59.380 Logon Error: 18456, Severity: 14, State: 11 . 2010-10-19 02:56:59.380 Logon Login failed for user <Server name>\User1'. Reason: Token-based server access...

Troubleshooting tempdb growth due to Version Store usage Recently I worked on an issue where the tempdb database version store cleanup was not occurring. I created a small repro to demonstrate the behavior. My tempdb has been showing the version store usage below for the past 3 days: ...

An overview of the inner working of a replication monitor We might see large number of Pending transactions on one of the Publisher in P2P replication. But when we check the Replication Monitor for second server (Subscriber) it might show a small value (which would be the actual value). You might...

PROBLEM DESCRIPTION ================ While performing Restore Database task in SQL 2000 from Enterprise Manager it may hang or appears hung at times . H owever you may not find any specific errors in the SQL server error log, application log and system event log. CAUSE ====== ...

· Disclaimer : Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when...

It’s a very common scenario where customers have their database encrypted and hold multiple certificates on their SQL Server environment. In this blog I would be sharing some good information on steps to restore full backup that was taken at the time when the database was not encrypted and applying the...

Problem Description =============== · After role reversal in a log shipping setup, the stored procedure sp_help_log_shipping_monitor may return the following error OR we may find the error in the log shipping report in SQL Server Management Studio. Msg 2627, Level 14, State 1, Procedure sp_help_log_shipping_monitor...

Problem Description ======================================= We encountered a situation where we were trying to execute a maintenance plan to rebuild the index of OperationsManagerDW database. However, the maintenance plan fails to complete. In the Maintenance Plan log, the following paragraph...

Some of you may experience problems while using Database Mail on SQL Server 2005 or SQL Server 2008 which will not be able to send emails to the database users. The SQL Server error logs will log following errors: The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue...

BEHAVIOR/SYMPTOMS: We recently had a customer come to us seeking help on a performance issue that he was experiencing. Understood, that there’s a web-application written in ASP.Net and was using SQL Server at the backend. During the peak usage hours, the application users were experiencing query below...

Consider a scenario where SQL 2000 has been uninstalled and Hotfixes are still visible. In my case it was hotfix 2050 and 2273. One will find the hotfix components visible in the ADD\REMOVE program. In that scenario attempts of removing the hotfixes are unsuccessful from the ADD\REMOVE programs. Attempts...

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.msdn.com/psssql/archive/2009/03/09/how-to-use-computed...

Consider the following scenario where you upgraded a database from sql server 2000 to sql server 2005 instance and changed the compatibility of the database to 90 and now you wish to drop the Full Text catalog which was originally created in the sql server 2000 database and is still present in the upgraded...