The first part will create 2 stored procedures with self-explanatory names. The second is a standalone SQL that may be used in any stored procedure, script or DTS package.
The generated string does not have any spaces and include only lower-case letters. To include anything else just change the boundaries for ASCII codes in the script.
The RandomString procedure requires the string length as a parameter while RandomNumber needs the lower and upper boundaries as parameters.
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.