• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

xp_readerrorlog with parameters gets stuck on 2005 but not in 2008 servers.

can you please run this in a 2005 server. do you get results back? if not, then may it is a new feature in 2008?

DECLARE @StartTime datetime  
DECLARE @EndTime datetime  

SELECT @StartTime = create_date from sys.databases where name = 'tempdb'
SELECT @EndTime =  GETDATE()  

EXEC master.dbo.xp_readerrorlog 0, 1, 'Starting', 'up', @StartTime, @EndTime , 'asc'
1 Solution
lcohanDatabase AnalystCommented:
It's working fine on SQL 2005 as well - what service pack you have installed and login access/rights when you run it?

This is what I get on my 2005 SP3
LogDate      ProcessInfo      Text
2013-10-22 00:58:59.300      spid7s      Starting up database 'master'.
2013-10-22 00:58:59.420      spid7s      Starting up database 'mssqlsystemresource'.
2013-10-22 00:58:59.600      spid11s      Starting up database 'model'.
2013-10-22 00:58:59.750      spid11s      Starting up database 'tempdb'.
2013-10-22 00:58:59.980      spid24s      Starting up database 'msdb'.
2013-10-22 00:58:59.980      spid25s      Starting up database 'xxxxxxxxx'.
2013-10-22 00:58:59.980      spid23s      Starting up database 'xxxxxxCRM'.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now