Thanks for the suggestion PW but the funny thing is this statement works fine exactly the way it is in our production environment except we are linking only two servers...

After a day of messing around, I was able to determine that the application that tied to the database (Label Printing Application) used Arial as it's font for printing....

Thanks for the info on the duration filed. That makes sense. If I run all the SQLs records in qry analyzer, it takes roughly 20-30 seconds.

I’m going to...

Here are some more useful quotes

"AUTO_SHRINK only reduces the size of the transaction log if the database is set to SIMPLE recovery model or if the log is backed...

Thanks for the info, some of it was new to me. Unfortunately I'm look for some more 'real world' references.

I should have put more information in the last email....

Here is what I know and it is not a lot. I'm not an expert.

The shrink command will remove unused space from the DB. If preformed after...