Hi,

Here is a script that will work for SQL2000 too.

DECLARE @WeakPwdList TABLE(WeakPwd NVARCHAR(255))

--Define weak password list

--Use @@Name if users password contain their name

INSERT INTO @WeakPwdList(WeakPwd)

SELECT ''

UNION SELECT '123'

UNION SELECT '1234'

UNION...