To apply ALTER DATABASE statement accross the Servers

PandianS
Posted by PandianS under Sql Server category on | Views : 1855
1. Linked Server should be enabled between the Servers.
2. Apply the statement given below
EXEC ServerName.master.dbo.sp_executesql('ALTER DATABASE DotnetFunda...')

Comments or Responses

Login to post response