Post reply

SELECT name, type, type_desc FROM master.sys.server_principals

  • May 31, 2011 at 5:32 am

    #100385

    Dear Sir,

    I run the above statement for getting Connection Authentic mode (SQL Mode), but I am getting the invalid object name like

    Msg 208, Level 16, State 1, Line 1 Invalid object name 'master.sys.server_principals'.

    Thanking You

    Debasis Bag

  • May 31, 2011 at 5:56 am

    #1331907

    Works for me on sql 2005 with case sensitive server so the query is good.

    Are you sure this is sql 2005 and not 2000-?

    Can you run that query login in as SA?

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

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