Have you checked to verify the linked server referenced in the stack dump? Could be an issue there (security/external to the linked server) and whenever this query gets run,...

[Btw, unless this was a deliberate attempt to cause an issue, be-atching about it just slows you down, and may upset others; be-atch after it's cleaned up, if you...

Maybe something like this?WITH Data (col1, col2, col3, Docket_date) AS

(

SELECT col1, col2, col3, Docket_date FROM dbo.DocketTB ORDER BY Docket_Date DESC

UNION ALL

SELECT col1, col2, col3, Date_Raised FROM dbo.WorkshopTB ORDER...

The trace option is probably a good place to start in finding your culprit (my preferred method) - although i'd probably create a custom trace in profiler say tracking only...

Of course I know NOLOCK/READUNCOMMITTED is the same thing 🙂 I wasn't meaning to say that ALL locking happens in the vendors app, I was meaning to say that...

I hear what you guys are saying. It's mostly trying to talk the reporting guys out of attempting to handling EVERYTHING within the SQL stored-procedure and encourage them to...

I think I got around it...pasted it from my iPhone!

I've set this up with the central logging table on a database server, and have all other (desired) SQL Servers...

I can't post the code from the office due to our proxy server not liking some of the keywords in the sql code, I can either email it to you...

What version of SQL are you using?

Also, check out this prior post - looks like it could be helpful

http://www.sqlservercentral.com/Forums/Topic565482-6-1.aspx#bm936680

I've created an automated process that logs all the CREATE, DROP, ALTER events from the default trace file into a centrally stored table (basically using a stored-procedure and a SQL...

Take the following example:DECLARE @String varchar(15)

SET @String = ' 012 4567 '

SELECT LEN(@String), DATALENGTH(@String)

LEN() excludes trailing spaces, so when you use it in your WHERE clause I believe it's actually...

Wait a minute....if you have unique clustered indexes what's the issue with creating the primary keys? It would make your entire issue with replication much easier! Is there...

You can override the data source credentials on the report server. Go to the data sources and set the account you want to use, then in your BIDS project,...

Snapshot replication is what you're stuck with...I've not heard of 3rd software that would handle it (then again I probably wouldn't have heard about it anyway, they don't let me...

Well that is good news, however if you post the errors the people willing to help just might be able to help you through the situation...so in the future should...