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)