Tag: "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… 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 AS… more »
