Home Forums Article Discussions Article Discussions by Author Discuss content posted by sunshine SQL Server Security Extract (Reverse Engineer) for ALL Databases RE: SQL Server Security Extract (Reverse Engineer) for ALL Databases

  • August 4, 2011 at 8:54 am

    #1363706

    change the sub-select collation:

    ...from...

    from (

    select dp.name as database_principal_name, sl.name server_login_name

    ...to...

    from (

    select dp.name COLLATE SQL_Latin1_General_CP1_CI_AS as database_principal_name, sl.name server_login_name