The Secret Diary of Han, Aged 0×29

When investigating SQL server size problems you can use the following commands from within query analyzer

• exec sp_spaceused tablename
• dbcc shrinkdatabase( databasename )

for example:

exec sp_spaceused AlertFilter

dbcc shrinkdatabase(onyx)