Poorly worded question. What if I wanted to check for startup errors? I knew I should have waited until tomorrow to answer.

Terry

I have learned something from this and similar questions with no correct answer given. Wait until the next day to answer so I don't screw up my score! Unfortunate but...

Cool question. Easy enough to find the answer but a function I did not know of. Thanks.

I knew I should have waited for the answer on this. As is often the case here, there is no 1 correct answer.

Terry

And MS could improve BOL with remarks on the performance. I got it wrong also but good question.

So as not to ruin my average , I waited until the answer was provided! Another question of dubious merit.

Terry

Counters set to 0 are still providing info on how the indexes are used. The correct answer is A. Perhaps these questions should educate rather than try to trick.

They are probably orphaned users as others stated. However, if this is SQL2005, you can create users without logins with the "WITHOUT LOGIN" option in CREATE USER. This new type...

How does this question get by ANY review? It is best to leave this issue open for discussion, not for quizzes, especially with all the fuss over sp2 and subsequent...

You will find the program as a menu item in SSMS, along with SQL Prompt if you use it. There is an issue so if the menu item is greyed...

I agree that this is poorly written for the reasons given before me. But, I got it right without waiting for tomorrow!

Not currently, but less than 2 years ago. Flowcast is a popular healthcare applicaiton, and the CACHE OOD from Intersystems underlies it. 

The answer depends on how you configured the linked server. In the end, The login that was used to connect to the remote server is correct. It could be hard...

The stored proc still checks for SA in 05. There are some new agent permissions you can set, but so far, none I tested will show the current status of...

To see executing jobs in Enterprise Manager you need to be SA. The only way around this is to hack the system stored procedure, if you are up to it, msdb.dbo.