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.
ALTER PROCEDURE [dbo].[PagedUserList] ( @PageIndex int, @NumRows int, @SearchText nvarchar(1000) ) AS BEGIN DECLARE @nSQL nvarchar(1090) SET @nSQL = 'SELECT (SELECT COUNT(*) FROM Users WHERE '+@SearchText+') AS MemberCount' EXECUTE sp_executeSQL @nSQL DECLARE @startRowIndex int; SET @startRowIndex = (@PageIndex * @NumRows) + 1; DECLARE @wSQL nvarchar(1090) SET @wSQL = 'WITH ItemEntries AS (SELECT ROW_NUMBER() OVER (ORDER BY LastName DESC) AS Row, UserID, FirstName, LastName FROM Users WHERE '+@SearchText+')' EXEC sp_executesql @wSQL SELECT UserID, FirstName, LastName FROM ItemEntries WHERE Row between @startRowIndex and @StartRowIndex+@NumRows-1 END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.