Ok, so maybe some system table is taking up space?
SELECT TOP 10
table_or_view = OBJECT_NAME(id), rows
WHERE indid IN (0,1)
AND OBJECTPROPERTY(id, 'IsMsShipped') = 1
ORDER BY rows DESC;
You said basically that shrinking doesn't work. But what *exactly* is the
DBCC SHRINKFILER(SNRDEV_Data, 1)
Of course, final silly question, you are running these queries from SNRDEV,
right? And that is the database you are trying to shrink?
SQL Server MVP