Tags: sp_msforeachdb
Did you track the growth of your database-backup?
May 7th
Frequently you'll want to know how fast your database-backup has been growing. Perhaps you have implement a SAN Backup-Device for Backup-to-disk, or you only want know how fast your database has been growing. This TSQL statement will query the [msdb]..[b… more »
Orphan SQL-Server accounts
Apr 18th
By using SP_MSForEachDB you can detect and display orphan SQL-Server accounts from all the databases of your SQL-Server.EXEC SP_MSForEachDB 'USE [?]; -- SYSTEM DATABASE ARE EXCLUDED IF DB_ID(''?'') > 4 SELECT ''?'' as DBName, name… more »
XML Feeds