I will try running DBCC UPDATEUSAGE (0) at the beginning of the script. I think you guys are correct although I can't confirm because that db is remote and unaccessible...
Thanks. That's an elegant approach to batching a large result set. There's one complication: Many of the tables I delete/archive are Order-related. The order_header table has one record per...
Yes, I did use sp_helpfile to determine the logical name to use as the first parameter of the DBCC SHRINKFILE. The logical names are the same as those shown in...
I didn't execute a "Use pubs" command, however, I did make sure the correct database was selected in the Query Analyzer's db dropdown list. I assume this is the same....