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.
CREATE TABLE CONFIGURATION ( Name VARCHAR(100) NOT NULL, NType VARCHAR(100) NOT NULL, Data VARCHAR(100) NOT NULL, Datatype VARCHAR(100) NOT NULL, DataVal VARCHAR(100) NOT NULL, Remarks VARCHAR(100) NULL) GO ALTER TABLE CONFIGURATION ADD CONSTRAINT PK_NTD PRIMARY KEY CLUSTERED (Name, NType, Data); GO CREATE TABLE Settings ( ID INT NOT NULL, NKey VARCHAR(100) NOT NULL, Value VARCHAR(100) NOT NULL, Remarks VARCHAR(100) NULL ) GO ALTER TABLE Settings ADD CONSTRAINT PK_IDNkey PRIMARY KEY CLUSTERED (ID, NKey); GO
IF EXISTS (SELECT 1 FROM CONFIGURATION WHERE Name= 'Auditing' AND NType = 'Audit' AND Data= 'AuditDt') BEGIN UPDATE CONFIGURATION SET Datatype = 'D', DataVal = '11/26/2013', Remarks = 'Audit Date' WHERE Name= 'Auditing' AND NType = 'Audit' AND Data= 'AuditDt' END ELSE BEGIN INSERT CONFIGURATION ([Name],[NType],[Data],[Datatype],[DataVal],[Remarks]) VALUES ('Auditing','Audit' ,'AuditDt','D','11/26/2013','Audit Date') END
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.