password expiration

• Art-251407

  Right there with Babe

  Points: 768

  More actions

  July 23, 2008 at 2:26 am

  #123355

  hi DBAs,

  Is there a way in sql 2005 to change/update expiration date for sql id?. How to know in SSMS those expired sql id?

  thanks,

  Art

• VastSQL

  SSC-Dedicated

  Points: 36121

  More actions

  July 23, 2008 at 4:20 am

  #846893

  As far as i know you can set a login to expire ,only password is set to expire for a particular login..