insisting on a password policy for sql

Is it possible to force users with sql accounts to use secure passwords say
6 plus characters long with numbers and letters. Is it also possible to have
sql insist that the passwords be changed every X days.
I am of course talking about when sql server 2000 uses sql authentication.
Please advise
AndreHi
SQL Server 2005 introduces this functionality.
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre|||The short answer for SQL 2000 is No.
A much longer answer is that one could 'roll their own' and create some
overly complex custom functionality that most likely would still be
incomplete and fraught with problems.
Waiting for SQL 2005 -and lobbying for its' adoption, is the answer.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre