To apply ALTER DATABASE statement accross the Servers

1. Linked Server should be enabled between the Servers.

2. Apply the statement given below

EXEC ServerName.master.dbo.sp_executesql('ALTER DATABASE SQLServerBuddy...')

No comments:

Post a Comment