Creating a Random Password in SQL Server

The following SQL Server stored procedure can be used to generate a random string which can be used in as a password.

CREATE Procedure RandomPwd @pwdLength int = 8 ,@Password varchar(30) = null output AS SET NOCOUNT ON SET ROWCOUNT @pwdLength SET @Password = '' SELECT TOP 8 @password = @password + char(number) FROM master..spt_values WHERE type='p' AND ( number between 48 and 57 OR number between 65 AND 90 OR number between 97 AND 122 ) ORDER BY newid() SELECT @Password RETURN @@error GO