Advertisement
Guest User

Untitled

a guest
Aug 21st, 2014
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. ForEach($Database in (Get-ChildItem -FORCE SQLSERVER:SQLlocalhostDEFAULTDatabases))
  2. {
  3. Write-Host $Database
  4. }
  5.  
  6. ForEach($Database in (Get-ChildItem -FORCE SQLSERVER:SQLlocalhostDEFAULTDatabases))
  7. {
  8. Invoke-Sqlcmd -Database $Database -HostName WIN-MAINV98PDFA -Query "select db_name()" -ServerInstance LocalHost
  9. }
  10.  
  11. Invoke-Sqlcmd -Database Test_1 -HostName WIN-MAINV98PDFA -Query "select db_name()" -ServerInstance LocalHost
  12.  
  13. Invoke-Sqlcmd -Database [Test_1] -HostName WIN-MAINV98PDFA -Query "select db_name()" -ServerInstance LocalHost
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement