Here's the SQL Server 7.0/2000 Version

use master
go
set nocount on
print '-------- Weak Passwords --------'
select 	distinct s.name, 
		d.word as password 
from 	dict d, -- Make sure your table 'dict' exists with the 'word' column and contains your dictionary
	sysxlogins s 
where pwdcompare(rtrim(d.word), s.password) = 1
print '--------------------------------'
go
-- Aw heck, lets check for Nulls while we're at it
print '-------- Null Passwords --------'
Select name,
      Password
from syslogins
where password is null
and   isntuser = 0 
order by name
print '--------------------------------'
go










-- Here's a 6.5 version

use master
go
set nocount on
print '-------- Cracked Passwords --------'
select 	distinct s.name, d.col001 as password 
from 	words d, syslogins s 
where pwdcompare(d.col001, s.password) = 1
go
-- Aw heck, lets check for Nulls while we're at it
print '-------- Null Passwords --------'
Select name,
      Password
from syslogins
where password is null
order by name
print '--------------------------------'
go