I have a function called GET_LOCAL_SERVER_VALUES_UDF which exists in the master DB on all servers. Each version is different.

I am going around the servers adding a new line of code to the function.

When I check in the function on a server I get message:-

"Would you like to deploy these changes to all linked databases?"

I select NO but what I find is:-

• The code on the server is not changed.
• The code in SQLDBC is changed for all servers.

This is a major hassle for me.

So I thought I would try to turn off the linked databases but I cannot find anything that controls this.

HELP PLEASE

To Delete a linked database group, go to Tools > Manage Linked Databases.  Expand the Linked Databases group and then right-click on the group you want to delete, select Delete group.

With linked databases, the code in SQLDBC is always changed on all servers, but the code on the linked servers is only changed if you choose Yes when you get the message box below.

Hope that helps.

Thanks, did that. Phew.

To create a Deploy group, select the objects you want to deploy, click on Deploy and select and add the databases you want to deploy to.  Then click on the Save button and enter a name.  Then deploy as normal.

Subsequently, when you next attempt to deploy the deployment group you created above will be in the Deployment Groups folder in the tree view.