Post reply

In sysusers table - Onle column is isaliased - Can you please tell me what is it meaning

  • March 8, 2014 at 12:03 pm

    #286553

    I have checked sysusers table in sql server 2008.

    There is one column name called isaliased - If it is 1 = Account is aliased to another user.

    But I m not getting account is aliased to other user meanin.

    Please help and explain me any one.

  • March 9, 2014 at 4:48 am

    #1695363

    If you're not using SQL Server 2000, you should be avoiding aliasing users. sp_addalias is deprecated functionality. I don't even think it's available in SQL Server 2008 or higher. Also, the sysusers table is just there for backwards compatibility. You should be referencing sys.database_principals if you're on 2005 or higher SQL Server systems. You'll note that there's no alias functionality there.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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