Thanks for the reply. There was data for the dates. What I ended up doing is similar to using a temp table in a way. I didn't use the...

I'm sorry for the error in the topic heading. It should read ...integrated with Sharepoint 2010.

On SQL Server 2005, sp3, standard ed, 32bit instance I created the linked server to a SQL Server 2012, sp1, standard ed, 64bit instance. The link is SQL Server type,...

THere are no scheduled tasks on the server at the times we receive the login failure. No SSIS packages, no SQL Agent jobs at these times either. I don't...

Can you explain the obsfuscated de-obfuscated a little more? How can I tell where this login attempt is coming from? The last 3 days the timing of it...

Awesome, that works too. I thought that it should be able to make the conversion from varchar to datetime, but just couldn't get the syntax.

Thanks very much.

The field is coming in from another source that has all fields as varchar. I used this from your example to change getdate to char and it works good...

Thanks very much, that worked.

I tried that but still had the error. So I commented out the first filter line assuming the last one covered it as well.

--exec sp_trace_setfilter @TraceID, 10, 0, 7,...

Additional information, I meant to say that the trace is filtered on a single user login.

Thanks again.

Was this ever solved? I have the same problem. My goal was to schedule a trace to run at a certain time. I created the trace and exported...

How do you make that mapping? Is it part of the script to create the link? report is a user login on both servers with the same password....

This worked, I had to add an else and end and it worked like I needed.

SELECT ID,

MAX( CASE WHEN Name = 'Description' THEN Type...

That's about all I have to work with. I didn't see how to do it but was hoping someone else could.

Thanks though.

The results I'm trying to get are:

proc_id dtime proc_num result

70360 ...