Awesome! DBCC SHRINKFILE did the trick!

The odd part is that we had 6 files/filegroups, and I didn't need to execute this on 4 of the 6 groups...

Gee, I got all excited for a bit, but alas, I'm running SQL Server 2000, with all the latest fixpacks.

When trying to drop a file, how does SQL 2000 know...

OK, neither one of those shows what I'm looking for (they all display that everything belongs to PRIMARY).

Let me provide some additional info. We create separate file groups for...

By the way, it's NOT the PRIMARY filegroup; I know you can't drop that one.

Chuck

That's just it, I don't know. I'm trying to drop the file itself associated within a particular filegroup, but EM doesn't say what object is still in it, just...

That's basically what we came up with, since there is a practical limitation. However, we want to 'roll off' each month as it becomes stale (basically, eliminate to long...

This is for a very high volume database for check records (Over 10,000,000 per day), being received from multiple banks. Each bank has their own table, which is UNION'ed...