External auditors love this kind of stuff. You need emails to CYA if management insist.

Several years ago, I actually started BCC'ing emails to my web based private account to CYA...

Unless you have the switches set to produce a report text file, you'll never know unless there is soemthing in teh SQL error log.

Check the job command line to see if...

Try this:

back it up

reconnect to the box as "sa"

restore it

(not tried it myself)

I'd expect this. What are you asking?

This is an average figure, over 249 extents or between 1985 and 1992 pages.

An average of only 4.1 bytes difference free per page. 1992...

I agree with SQLBill, but a bit of a typo...

RESTORE DATABASE dbname WITH RECOVERY

No, you are not wrong.

This is a problem that has been around for ages in SQL Server.

It drove me nuts, I had to restart the SQL services if the email servers were bounced or...

In this case, just remove the transaction handling - it's just overhead

It just cuts down the number of perfmon counters loaded and used.

I guess these ones are more intensive to monitor, thus leaving them out frees up resources.

It will have no...

I've not used this myself.

But it (from BOL):

"Disables the keeping of CPU time and cache-hit ratio statistics. Allows maximum performance."

It doesn't "sacrifice the cache hit ratio".

Without using BEGIN and COMMIT etc, each DML statement is a transaction in itself.

You can use SET IMPLICIT_TRANSACTIONS ON to do an implicit BEGIN TRAN if you wanted

In your case,...

The query optimiser may be applying the WHERE in the view after the ISNULL.

In the SQL Server engine, then there is no guarantee of the JOIN being executed before the WHERE...

But you can change the number kept via EM...

This group is in AD by default, just change to advanced view...

But you don't need to do this!

What happens is that the domain account for SQL server can not read...

Use the scm command line util that comes with SQL to change pwd, stop services, start services etc

See BOL for more

Knock up a batch file that just need runs on each...