How to Update ACVSCore.dbo.ApplicationServer with Transact-SQL in SQL Server Management Studio

Article ID: SWH-KB-nID-000006849

Published: Oct-20-2022

 

  1. First check to see what the current values of the relevant fields in the table are with a SELECT statement.

 

 

SELECT ObjectID, MachineName,uri,IPAddress FROM ACVSCore.dbo.ApplicationServer

 

 

  1. To ensure that the ACVSCore.dbo.ApplicationServer table is updated accurately, use a T-SQL statement such as:

 

 

UPDATE ACVSCore.dbo.ApplicationServer

SET 

MachineName = ‘NewHostName’,

uri = ‘net.tcp:/NewHostName.domain.tld:8999/CrossFire/IClientSession’

WHERE ObjectID = 5000

 

 

  1. When you execute this T-SQ Statement, you should see (1 row affected) in the Messages pane if it was successful. 

 

 

  1. If the system is part of an Enterprise, either a MAS or a SAS, the ObjectID will be different, and you must also update the IP Address column as such:

 

 

UPDATE ACVSCore.dbo.ApplicationServer

SET 

MachineName = ‘NewHostName’,

uri = ‘net.tcp:/NewHostName.domain.tld:8999/CrossFire/IClientSession’,

IPAddress = ‘10.10.10.10’

WHERE ObjectID = 2097152002

 

 

CCURE9000_SWH-KB-nID-000006849_lt_en-1.pdf