Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
ALTER PROCEDURE [dbo].[OverwriteCorrections] AS DECLARE @rows INT, @TruckNo nvarchar, @FieldTag nvarchar SELECT @rows = COUNT(1) FROM tbl_Corrections WHILE (@rows > 0) BEGIN SELECT TOP 1 @TruckNo = TruckNumber, @FieldTag = FieldTagnum FROM tbl_Corrections IF EXISTS (SELECT * FROM tbl_ImportExtAG WHERE FieldTagnum = @FieldTag) UPDATE tbl_ImportExtAG SET TruckNumber=@TruckNo WHERE FieldTagnum=@FieldTag ELSE INSERT INTO tbl_ImportExtAG(TruckNumber,FieldTagnum) VALUES (@FieldTag,@TruckNo) DELETE FROM tbl_Corrections WHERE FieldTagnum=@FieldTag SELECT @rows = COUNT(1) FROM tbl_Corrections end