The only method I know of that would allow you to do this and have it readily available to view would be to run a constant SQL Profiler trace that...

Are you sure this is not an intrusion attempt?  I am assuming that by 'Application Event Log', you mean the Windows Application event log and not a log that is...

You will have to use the variable name to create a dynamic SQL string and use sp_executesql. 

declare @DBname varchar(20),

 @sqlstring nvarchar (4000)

set @dbname = 'testme2'

set @sqlstring = N'create database '...

Gloria Mark is a genius....reading her article was an interuption and it took me about 25 minutes to get back to work!!

In the case where your routine will return the defaut instance resource name, I don't know as I don't know what method your routine is using to determine the resource...

Is your slow response something new?  Is it only slow on this one specific server?  From a memory perspecitve, it does not look like you have AWE enabled.  With that...

What is the data type on the columns where your time is expressed with 10 numbers?

Sorry I could not be of more help....

Play around with the GETUTCDATE() function:

DECLARE @LocalDate DATETIME

SET @LocalDate = GETDATE()

-- convert local date to utc date

DECLARE @UTCDate DATETIME

SET @UTCDate = DATEADD(Hour, DATEDIFF(Hour, GETUTCDATE(), GETDATE()), @LocalDate)

-- convert utc date to...

I would suggest possibly using the job setup output file option to possibly catch more information as to why your .bats are periodically failing.  You may also want to write...

Oops, here's the presentation:

http://support.microsoft.com/default.aspx/kb/895614

Colin,

In your first post in this thread, you mentioned that you've seen Technet presentations.  I don't know if you've seen this one, so I'll post it anyway.  It talks about...

These forums are designed to provide a certain level of free help.  You may want to post your query and see what kind of responses you get.  Other hardware/storage/SQL...

Can you post your .bat file?

I hope you have a good backup/recovery strategy as this will be your most likey approach.  Here is a quote from MSDN:

TORN_PAGE_DETECTION

This recovery option allows SQL Server to detect incomplete...