SQL Scripts for Microsoft Dynamics GP: Change Web Service URi

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.

This script was created for a client to run to change the web service location when they copied the DYNAMICS database from production to either the dev or test servers; to allow for a single script to be used for both systems, the script includes an IF statement.

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (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).
*/
-- set parameter
DECLARE @Web_Service_Server AS VARCHAR(100)

IF @@SERVERNAME = 'DEVSQL-01\GP' -- dev
	SET @Web_Service_Server = 'devweb-01'
IF @@SERVERNAME = 'TESTSQL-01\GP' -- test
	SET @Web_Service_Server = 'testweb-01'

-- use parameter to update the WF00100 table with the new URL
UPDATE WF00100 --Workflow Setup (WF00100)
	SET Web_Service_Server = @Web_Service_Server
WHERE
	SETUPKEY = 0