• Oh yes, it's a really important proc.

    And it's there since V2000 at least I think 😀

    Yes, ALTER LOGIN is supposed to be the replacement, but it does not do the checking.. I have no news on that.. I think the'll gonna leave until all aspects are covered one way or another..

    guess we are expected to just ask the DMVs for that

    Andreas

    ---------------------------------------------------
    MVP SQL Server
    Microsoft Certified Master SQL Server 2008
    Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.insidesql.org/blogs/andreaswolter
    www.andreas-wolter.com