If you wanted to know whether or not an index had been used within a 6 month time period, wouldn't you have to run profiler for 6 months? Maybe...

Using either backup/restore or detach/attach, the orphaned users on the destination database will need to be dealt with in some way. Is that correct?

Thanks...

I want some FAT TIRE!!! LOL! Where do I get some? I'll share!

-TuxedoDBA

My company is using an IBM SAN with SQL 2000 Standard Edition, with no problems. I don't think Enterprise Edition is a requirement for SAN usage. The server...