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.
USE [GPSOL] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[UpdatedImeiNumber] ON [dbo].[Newtbl_DeviceMaster] -- table name AFTER UPDATE AS declare @imeiNumber as varchar(50) = '' begin IF EXISTS ( SELECT I.nIMEINo FROM INSERTED I JOIN DELETED D -- make sure to compare inserted with (same) deleted IMEI ON D.nIMEINo = I.nIMEINo AND D.nIMEINo <> I.nIMEINo -- only IMEI with changed name ) select @imeiNumber = (SELECT nIMEINo FROM Inserted) print 'inserting dummy record' insert into tblCommonTrackingData (vSequenceID, vpkDeviceID, dGPSDateTime) values('1', @imeiNumber, GETDATE()) end
select @imeiNumber = (SELECT nIMEINo FROM Inserted)