This link has scripts that can be used to cycle through each database on a server, or each table in a database.

http://www.sqlservercentral.com/scripts/contributions/900.asp

I’ve been using ER/Studio for several years, and have been pretty happy with it. Embarcadero is continually updating it, and they’ve added a number of nice features. We looked...

Here's another, potentially simpler, way to move everything into one filegroup. I've used this method on databases up to about 800 Mb.

I found out (by accident, of course) that when...