"On Success" or "On Falure" of step (5) from the previous comment DO NOT FORGET

(6) Either return Builtin\Administrators group to the members of System Administrators role OR add Agent Startup...

Hello,

Everyone is correct and the ansver selection is correct too. There is a typo in the explanation of the answer.

"Choosing an Edition of SQL Server 2000" article says clearly abot Personal...

David,

when you say you create your procedures in another database you don't mean Production database and Master database. If I understand you correctly and there is yet another database...

Hi, I would answer "User" is odd because it is NOT listed in System Functions list in BOL. I also checked BOL on MSDN to make sure. Check for yourself at

To prevent sysadmins to explore databases you need also password-protect database backups. But theoretically a sysadmin may stop SQL Server, copy a database file to another SQL Server computer and...

Steve, set up a Profiler or a Trace for the event "Audit Login Faled."

You will see the Application Name that is trying to connect.

The question is not correct for the first place.

1. The category of the question is NOT Administration

2. We don't really know what did they need for a day of theweek:...

I wonder why everyone is discussing the what is system and what is user tables and nobody noticed the syntax error! Try to run this script on Northwind database and...