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

OU

SELECT  LEFT(NEWID(), 8)