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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

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

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