Post reply

Login Property Issue

  • January 9, 2012 at 1:29 pm

    #251086

    Hello Friends,

    i am trying to check if the Check_Policy and Password_expiration is enabled or Disabled for a particular login. I can do this through SSMA but i would like to do this through TSQL.. i tried following thing but not getting null value for both enabled and disabled

    SELECT LOGINPROPERTY('TestUser', 'CHECK_EXPIRATION')

  • January 10, 2012 at 6:50 am

    #1431092

    If Password Policy is disabled then you will get NULL. If the OS does not support password policy, you will get NULL

    -Roy

  • January 10, 2012 at 6:50 am

    #1431094

    sqlquest2575 (1/9/2012)

    Hello Friends,

    i am trying to check if the Check_Policy and Password_expiration is enabled or Disabled for a particular login. I can do this through SSMA but i would like to do this through TSQL.. i tried following thing but not getting null value for both enabled and disabled

    SELECT LOGINPROPERTY('TestUser', 'CHECK_EXPIRATION')

    Check this

    http://msdn.microsoft.com/en-us/library/ms345412.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply