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.
declare @ssid varchar(max) declare @stid varchar(max) declare @RegionID varchar(10) set @ssid='acd5eb63-6cf5-4ae0-9d26-afa76f2cd83f' set @stid='' set @RegionID='' select distinct cstitle as PageTitle,substring(convert(varchar(4000),csChallenge),0,150)+'...' as Excerpt,'Client Success' as AreaName,'' as OfficeName,convert(varchar(38),tbl_CS_Master.csID) as csid ,'' as ksID ,'' as "Filename" ,'' as ks_FName ,'' as ks_LName from tbl_CS_Master left join tbl_cs_service on tbl_cs_service.csid= tbl_CS_Master.csid left join tbl_CS_Regions on tbl_CS_Master.csID = tbl_CS_Regions.csID where (convert(varchar(36),tbl_cs_service.ssid) in (select cast(value as uniqueidentifier) from dbo.ParmsToList(@ssid)) or @ssid is null) and (tbl_CS_Regions.RegionID in (select cast( value as int) from dbo.ParmsToList(@RegionID)) or @RegionID is null)
|OSQL to execute sql command||26||25|
|Syntax error with Dates where clause||10||50|
|MS SQL: Getting all rows not just one , combining multiple queries||11||27|
|Substring works but need to tweak it||14||16|