Browse Site by Tags - MSMVPS.COM

How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications How to make unwanted access to SQL Server 2005 by...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-12-2007
Filed under: sql server, security, kba, access, sa, system administrator, operation system

FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-22-2007
Filed under: sql server, kba, access, agent, account, proxy

FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view in SQL Server 2005

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-14-2007
Filed under: sql server, dmv, kba, violation, access, sys.dm

FIX: You may receive an access violation or error 942 when you drop a database in SQL Server 2005

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: You may receive an access violation or error 942 when you drop a database in SQL Server 2005...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 07-10-2007
Filed under: sql server, database, kba, violation, access, drop

FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 06-27-2007
Filed under: sql server, restore, database, kba, access, checkpoint, denied