Showing posts with label Alter Database on Remote Server. Show all posts
Showing posts with label Alter Database on Remote Server. Show all posts

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...')