Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
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 @row INT; DECLARE @string VARCHAR(50), @length INT, @code INT; SET @row = 0; WHILE @row < 100000 BEGIN SET @row = @row + 1; -- Build the random string SET @length = ROUND(80*RAND(),0); SET @string = ''; WHILE @length > 0 BEGIN SET @length = @length - 1; SET @code = ROUND(32*RAND(),0) - 6; IF @code BETWEEN 1 AND 26 SET @string = @string + CHAR(ASCII('a')+@code-1); ELSE SET @string = @string + ' '; END -- Ready for the record SET NOCOUNT ON; INSERT INTO [SP].[SMSG].[TMSG VALUES ( -- @row, @string, ROUND(2000000*RAND()-1000000,9), ROUND(2000000*RAND()-1000000,9), GETDATE(), CONVERT(DATETIME, ROUND(60000*RAND()-30000,9)), null, null, @string, @string, null, null ) 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.