Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Import-Module sqlps -DisableNameChecking
- $dbs = Invoke-SqlCmd -ServerInstance 'localhost' -Query 'select name from sys.databases where database_id > 4'
- foreach($db in $dbs){
- Invoke-Sqlcmd -ServerInstance 'localhost' -Database $db.name -Query 'select count(1) from sys.objects'
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement