Revlogin Issue in SQL 2008 R2 Standard Edition

• pawana.paul

  SSCommitted

  Points: 1686

  More actions

  September 11, 2012 at 11:14 am

  #263958

  Hello All,

  I am working on Side-by-Side upgrade from SQL Server 2005 Standard Edition to SQL Server 2008 R2 Standard Edition.

  As per http://support.microsoft.com/kb/918992 (Method 3, Step 2) completed successfully. When I use "EXEC sp_help_revlogin", I am getting the below error:

  Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 11

  Invalid object name 'master..sysxlogins'.

  Please help.

  Thanks in advance.

• pawana.paul

  SSCommitted

  Points: 1686

  More actions

  September 11, 2012 at 11:19 am

  #1536405

  Sorry All.

  I could able to figure out the fix and taken care of it.