As Scott said learning the dynamic sql technique is a good one. And he is correct that sp_msforeachdb has a bit of overhead. I would however say that with 700 databases it isn't overkill. You are going to have to write a cursor to traverse that many databases. I doubt that a roll your own variety will have that much less impact than the built in one. You could certainly try both and test performance.