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 PROCEDURE Coll2014_FindResidentForRegistration -- Add the parameters for the stored procedure here @FName char(35), @LName char(30), @BDate char(10), @SSNum char(4) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here select OccuSeqNo,RTRIM(a.propertyid)+'-'+RTRIM(a.BldgId)+'-'+RTRIM(a.unitid)+'-'+rtrim(a.resiid) as fullid, b.status,b.ListedDate,b.OriginalAmt from TAG_eSite.dbo.occupantheader a right outer join CollectionSystem.dbo.Collection_Master as b on RTRIM(a.propertyid)+'-'+RTRIM(a.BldgId)+'-'+RTRIM(a.unitid)+'-'+rtrim(a.resiid) = b.fullid where OccuLastName = @FName and OccuFirstName = @LName and Birthdate=@Bdate and RIGHT(OccuSSN,4)=@SSNum END