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.

You'd have to query information_schema.columns for the number of columns and then probably build a loop to sum up the values.

Note that storing an variable number of fees in the...

As stated above, the parser must be able to resolve the table at compile time. So variables must be declared table variables or a name given.

You can

exec(' select *...

Or write up a short article. It's always good to see how someone tests and their results.