|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Tuesday, October 23, 2012 8:48 AM
Points: 71,
Visits: 114
|
|
When I look in Enterprise Manager under Management, SQL Server Logs, it shows (no items). There is an errorlog, I can read it by running a query, xp_readerrorlog, and it is in startup jobs. Does anyone have any ideas why the logs do not show in EM? I have tried to research this on the internet with no results. I just started monitoring this system so I don't know the history of it. Any Ideas?
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Yesterday @ 2:11 PM
Points: 3,108,
Visits: 2,114
|
|
Could it be a permissions issue ? Are you using the same credentials for EM that you use in QA to run xp_readerrorlog ?
Regards Rudy Komacsar Senior Database Administrator
"Ave Caesar! - Morituri te salutamus."
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Tuesday, October 23, 2012 8:48 AM
Points: 71,
Visits: 114
|
|
Yes, I am signed on the server when I open EM and when I run the query. I run the query from EM.
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Thursday, October 11, 2012 9:51 AM
Points: 16,
Visits: 107
|
|
| Do you have the sysadmin role either given directly to your user or via a group? I have just added this to a test user and this user can now see the SQLServer logs whereas before they were missing from the menu in Enterprise Manager.
|
|
|
|