Need to alter entry in orion database and want to have my SQL statement verified

pimp_vader

I don't work too often with SQL, and while I have a familiarity with it I am not confident enought to make changes to my solarwinds database without running my query by some others for advice, syntax checking, etc. SO Here is the statement I have concocted, please feel free to tear it apart but please do offer suggestions also.

Thanks

DECLARE @UpdateWebSite VARCHAR(20)

SELECT @UpdateWebSite = 'UpdateWebSite'

BEGIN TRAN UpdateWebSite WITH MARK N'Updating Websites to include FQDN';

GO

USE [SolarWindsOrion];

GO

UPDATE TABLE [SolarWindsOrion].[dbo].[Websites] SET COLUMN ServerName = 'Primary.solarwinds.poller.fqdn' WHERE WebsiteID = '4';

GO

COMMIT TRANSACTION UpdateWebSite;

GO

RichardLetts

Why not simply use the database editor [on the app server], open up the relevant table in 'edit mode', and simply make the change there?