It’s Time To Retire sp_MSForEachDB
Most DBAs know about this undocumented stored procedure. It loops through all the databases on a server and allows you to execute T-SQL statements against each one. I have feeling some people think this is better than writing your own cursor that does the same thing. It’s really not. In fact, if you go into […]