Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXEC sp_MSforeachdb N'IF ''?'' LIKE ''DB_Pattern%''
- BEGIN
- declare @DB_Name nvarchar(50)
- set @DB_Name = ''?''
- declare @Command nvarchar(MAX)
- set @Command = N''SELECT COUNT(*) FROM '' + @DB_Name + ''.dbo.TABLENAME''
- EXEC sp_executesql @Command
- END';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement