Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @DB_Name VARCHAR(100)
- DECLARE @Command nvarchar(200)
- DECLARE database_cursor CURSOR FOR
- SELECT name FROM master.dbo.sysdatabases WHERE name LIKE 'DB_Pattern%'
- OPEN database_cursor
- FETCH NEXT FROM database_cursor INTO @DB_Name
- WHILE @@FETCH_STATUS = 0
- BEGIN
- SET @Command = N'SELECT COUNT(*) FROM ' + @DB_Name + '.dbo.TABLENAME'
- EXEC sp_executesql @Command
- FETCH NEXT FROM database_cursor INTO @DB_Name
- END
- CLOSE database_cursor
- DEALLOCATE database_cursor
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement