Change Web Services for Microsoft Dynamics GP Web Server Location In All Companies

This script was created so once a live system was copied to a standalone test system, the web services server can easily be updated to the test server.

The highlighted section is the new server location which should be set:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DECLARE @SQL NVARCHAR(MAX)
SET @SQL = STUFF((
					SELECT
						CHAR(13)
							+ 'UPDATE

								WF

							SET

								Web_Service_Server = ''test.example.co.uk''

							FROM

								' + INTERID + '.dbo.WF00100 AS WF'
					FROM
						DYNAMICS.dbo.SY01500

					FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
EXEC sys.sp_executesql @SQL

Read original post Change Web Services for Microsoft Dynamics GP Web Server Location In All Companies at azurecurve|Ramblings of an IT Professional