This is one of the methods to generate 8 characters password randomly (combination of alphabets,numbers and special characters)
declare @password varchar(8) set @password='' select @password=@password+char(n) from ( select top 8 number as n from master..spt_values where type='p' and number between 48 and 122 order by newid() ) as t select @password
Tags: t-sql, sql_server, random_password,