• //** Use this query and you will all set**//txtPost_CommentEmoticon(':-)');

    USE Master

    GO

    ALTER LOGIN SQL_Account WITH PASSWORD = ‘currentpassword(SamePassword)’

    GO

    ALTER LOGIN SQL_Account WITH

    CHECK_POLICY = OFF,

    CHECK_EXPIRATION = OFF;:-)