You want to be sure the SQL Server is running OK, not sure if the Resource database causes issues with Sharepoint, but there is some integration with Sharepoint.

Worst case, put...

That's a good list and gets you most of the way there. I'd add some good T-SQL knowledge for writing reports. Seems like those come up constantly and there are...

Nope, SQL monitors SQL.

There are some file system solutions, but there really isn't a good way to do this and make it available to the security folks. Maybe set permissions...

Troy, that sounds great, but now you get the great view of the Rockies! Not sure which one I prefer.

The kids do get loud. Last summer, when we had them home part of the summer, it was hard to work. Ended up working at night a lot when they...

Why would you worry about productivity at home v the office? Plenty of people gab, goof off, walk around at the office and don't get things done.

You measure results. I...

I'd run profiler at this time and figure out exactly what is being run. Then you can make a plan to work with it.

No, the file itself has a timestamp, but that changes regularly. Changes to tables aren't tracked.

You could set up a datetime mark in each table and have it updated with...

Virtual PC is free, I'd recommend running it in a VM to be safe. The RTM is probably fine, but you don't want to create issues with your current environment.

Did you check the names of the files in sysfiles? Or in the database properties?

Not sure what you got here, but questions of the day are built 3-4 weeks ahead of time. Perhaps you saw the question early or it's a coincidence.

In any case,...

Please don't cross post.

Answer here: http://www.sqlservercentral.com/Forums/Topic554245-147-1.aspx

I don't like the idea of CLR code, but there have been a few people that have found it quite handy. I tend to side with those above and I'd...

Corruption errors are almost always hardware related, so I'd get the hardware checked.

You can try dropping and rebuilding the affected index, however that doesn't necessarily address the underlying cause.

REPAIR_DATA_LOSS should...

Second for Grant's advice.