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.
select dh.DhDocID, MAX( convert(varchar(10),dhrev)) as Latest_Rev, dh.DhCreateDate, a.AdLabel, a.AdValue, p.PjName from Doc_Header dh INNER JOIN Attribute_Detail AS a ON dh.DhID = a.AdDhID LEFT OUTER JOIN Project_Document_Relations AS pr ON pr.PdDhID = dh.DhID LEFT OUTER JOIN Projects AS p ON p.PjID = pr.PdPjID where (a.AdLabel LIKE '%job%') AND (dh.DhCreateDate > CONVERT(DATETIME, '2010-10-20 00:00:00', 102)) and dhdocid = 'ED - 17928' group by DhDocID,dh.DhCreateDate, a.AdLabel, a.AdValue, p.PjName
Join the community of 500,000 technology professionals and ask your questions.