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 [Database] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[Ascent_UpdateSupplierStatus] ON [dbo].[ApSupplier] AFTER INSERT,UPDATE AS INSERT INTO [TriggerTablesAscent].[dbo].[SupplierStatus](SupplierCode, ActiveStatus, DateUpdated, UpdatedBy) SELECT i.Supplier, CASE i.OnHold WHEN 'Y' THEN 1 ELSE 0 END, CURRENT_TIMESTAMP, SYSTEM_USER FROM inserted as i LEFT OUTER JOIN [TriggerTablesAscent].[dbo].[SupplierStatus] tta ON i.Supplier = tta.SupplierCode WHERE CASE i.OnHold WHEN 'Y' THEN 1 ELSE 0 END <> tta.ActiveStatus
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.