Monthly Archives: March 2011

Error “Alter failed for Server ‘[servername]’ “in maintenance plan’s “check database integrity task”

This error happened in one of the SQL2005 SP4 instances I am managing. The root cause of this issue is that the integrity check task runs statement ‘EXEC sys.sp_configure N’user options’, 0 RECONFIGURE‘ in the background and this statement conflicts with another “allow … Continue reading

Posted in SQL Server | Leave a comment

A very interesting paragraph from a Microsoft KB article about NT AUTHORITY\SYSTEM and BUILTIN\Administrators logins

The original article is here and the quoted text is as follows: The NT AUTHORITY\SYSTEM account The NT AUTHORITY\SYSTEM account is also granted a SQL Server login. The NT AUTHORITY\SYSTEM account is provisioned in the SYSADMIN fixed server role. Do … Continue reading

Posted in SQL Server | Leave a comment

How to become NT AUTHORITY\SYSTEM on Windows systems

As a DBA, you will bump into situations to trouble shoot weird things under this account. And this article details the way how to do it beautifully. Just before you follow the steps, you have to install a toolset from … Continue reading

Posted in SQL Server | 1 Comment