Login Password Policy

  • Lee Linares

    SSCrazy

    Points: 2693

    Comments posted to this topic are about the item Login Password Policy

  • genliang76

    SSC Rookie

    Points: 43

    when i try to run this script i am having an error when i try this on SQL 2008

    any idea what's wrong ?

    Msg 102, Level 15, State 1, Line 2

    Incorrect syntax near '?'.

  • Lee Linares

    SSCrazy

    Points: 2693

    It's not the code. I have run into this problem a few times when I copy code from this site. I seems that some Unicode characters get inserted in the code. If you try to save script from the query window in Management Studio I get a warning "Some Unicode characters in this file could not be saved in the current codepage."

    It seems that what LOOK like blank spaces are actually some unprintable character. If you delete the spaces on the lne indicated in the error and try it again you will get the same error but on a different line.

    Very frustating. What I end up doing is to highlight JUST ONE of the "blank" spaces and run Find and Replace with a real blank space. There is probably a better way.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

Viewing 4 posts - 1 through 4 (of 4 total)

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