EXEC sp_msforeachdb

 Below is the example.



The below query will change the owner of all the databases to sa at a time
sp_msforeachdb @command1='USE ?;IF DB_ID(''?'') > 4
begin
EXEC sp_changedbowner ''sa''
end'
Getting all the table information at time
sp_msforeachdb @command1='USE ?;SELECT * FROM sys.Tables'

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server