Just found this on The Daily WTF in a thread about a (misunderstood and therefore discussed) random password generator. Instead, this one creates random fixed-length 8-character passwords fairly easy in T-SQL:
SELECT LEFT(NEWID(), 8)
a@href@title, blockquote@cite, em, strike, strong, sub, sup, u