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.
Execute upMySprocHistory '11/1/2016', '11/1/2016', '100987','','',''
ALTER PROCEDURE [dbo].[upMySprocHistory] ( @FieldDateFrom Varchar(50) = '', @FieldDateTo Varchar(50) = '', @FieldCustNo numeric(6,0) = '', @FieldGroupCode Varchar(50) = '', @FieldQtyMin Varchar(50) = '', @FieldQtyMax Varchar(50) = '' ) AS SELECT * FROM viewHistoricalData v WHERE ((@FieldDateFrom = '') Or (v.DateCreated)>= @FieldDateFrom) AND ((@FieldDateTo = '') Or (v.DateCreated)<= @FieldDateTo) AND ((@FieldCustNo = '') Or Convert(numeric(6,0),(v.CustNo))= @FieldCustNo) AND ((@FieldGroupCode = '') Or (v.GroupCode)= @FieldGroupCode) AND ((@FieldQtyMin = '') Or (v.Quantity)>= @FieldQtyMin) AND ((@FieldQtyMax = '') Or (v.Quantity)<= @FieldQtyMax)