Tom Garth (4/11/2008)

---

K. Brian Kelley (4/11/2008)

---

Tom Garth (4/11/2008)

---

Great article Brian!

An application that I wrote has an interface for the app admin to create and manage users, and role memberships. It has been running on SQL 2000, but I will be migrating it this year to SQL 2005 (or maybe 2008).

Does SQL Server 2005 store any of the policy password rules locally. I'm wondering if I will be able to determine when a user's password is due to expire just by checking the availalbe SQL Server information.

Thanks,

I haven't seen it, but it wouldn't surprise me if the info is one of the management views.

Thanks Brian,

I'll be finding out soon enough. I'll try to remember to post back with the info when I do.

Regards,