10. January 2013 20:08
We have several SQL databases. Each for each client website. We also have a lot of servers running SQL server. When you need to clean up space, you sometimes know that there is just one big database .
sp_helpdb to the rescue!
And when you add a database name to sp_help ‘my_db_name’
you get all the files too…