Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Policy Based Mnagament - Check for orphaned users

    I found another solution.... this works better for me.

    --Orphaned Users Count Condition

    --Facet: Server

    --Expression:

    ExecuteSql('Numeric', '

    CREATE TABLE #orphanedusers(

    InstanceName nvarchar(50) default @@SERVERNAME,

    DatabaseName varchar(200) default db_name(),

    UserName nvarchar(50),

    UserSID binary(16)

    )

    DECLARE @command VARCHAR(1000)

    SELECT @command =...

Viewing post 1 (of 1 total)