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 [CollectionSystem] GO /****** Object: StoredProcedure [dbo].[Coll2014_GetWorkIDs] Script Date: 11/09/2016 18:35:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE [dbo].[Coll2014_GetWorkIDs] -- Add the parameters for the stored procedure here @PropID char(2) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here declare @WorkName nvarchar(100) declare @WorkAddr nvarchar(100) declare @WorkPhone nvarchar(100) set @WorkName = (select demogseqno from demographicdefn where fieldprompt= 'Work Name' and PropertyId=@PropID) set @WorkAddr = (select demogseqno from demographicdefn where fieldprompt= 'Work Addr' and PropertyId=@PropID) set @WorkPhone = (Select demogseqno from .demographicdefn where fieldprompt = 'Work' and PropertyId=@PropID) select @Workname,@WorkAddr,@workphone 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.