Post reply

Invalid object name 'master.dbo.sysxlogins'.

  • February 18, 2010 at 1:54 am

    #141297

    DEAR ALL,

    I WAS TRYING TO MIGRATE SQL SERVER 2000 TO 2005.FOR THIS I EXECUTE

    sp_hexadecimal PROC ON 2000.BUT Invalid object name 'master.dbo.sysxlogins'. ERROR MSG OCCURRED.PLEASE HELP ME AND TELL ME THE REASON WHY THIS HAPPENED.SAME PROC RUNNING SUCCESSFULLY ON DIFFERENT SYSTEM

    REGARDS

    AJAY BHARDWAJ

  • February 18, 2010 at 2:00 am

    #1120721

    why all CAPS???????

  • February 23, 2010 at 10:55 pm

    #1124097

    hiiiiiii

    to All

    I didn't get the answer till now pls provide me the solution

  • February 24, 2010 at 9:31 am

    #1124343

    By default, only members of sysadmins can access sysxlogins, so are you executing the stored procedure as a sysadmin?

    Greg

  • March 14, 2010 at 3:54 am

    #1133368

    yes I have sysadmin write...

    even then i am getting problem

  • March 14, 2010 at 9:33 am

    #1133395

    That was an undocumented table and looks like it's not in SQL 2005.

    You shouldn't be trying to use it anyway. Rather use one of the system views (depending what you're doing)

    sys.server_principals

    sys.sql_logins

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 15, 2010 at 1:44 am

    #1133544

    thanx bro,

    But i was migrating sql server 2000 to 2005..And i was running the proc on SQL SERVER 2000,But error occurred.I was asking 4 SQL Server 2000.

    And thanx 4 ur Reply...

    Regards

    Ajay Bhardwaj

  • March 15, 2010 at 1:54 am

    #1133548

    What error were you getting when trying to query that on SQL 2000?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 15, 2010 at 2:58 pm

    #1134089

    Can you see the table in the master database.

Viewing 9 posts - 1 through 8 (of 8 total)

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