I am happy you found a way forward but as a side comment I must say that your code raises several red flags. The dynamic cursor is a close second...

SW21_Bob (3/6/2013)

---

How does the use of synonyms effect performance?

More specifically, are synonyms replaced with fully qualified names in execution plans? It would seem to me that any synonym has to...

Here's how I usually handle it:

DECLARE @long_string NVARCHAR(MAX) = N'Hello world!';

SELECT @long_string AS [processing-instruction(long_string)]

FOR XML PATH(''),

...

What JeremyE showed...

Managing SQL Server on VMware[/url]

Thanks. I am pretty sure that aspect of C "fell off my memory queue" a long time ago 😛

At least...

You can check the dependencies of the table using the Catalog Views:

USE AdventureWorks2008R2;

GO

SELECT referencing_schema_name,

referencing_entity_name,

...

Yikes, not sure I know (or knew or remember) which might do...

I'll second that. I almost exclusively favor traditional temporary tables over the use of table variables. Performance is one reason, which you may be experiencing first hand, and ease of...

SSIS Packages are not backward compatible. You could rewrite the packages in 2008 format or you could install SQL 2012 in the production environment. SSIS 2012 Packages will happily communicate...

You would modify your proc to set CONTEXT_INFO before you did the UPDATE.

SET CONTEXT_INFO 0x1256698456

Then in your trigger you would check CONTEXT_INFO and if you found it had the...

ddg8885 (10/20/2010)

---

I searched the error for a while and saw a lot of things about certificates differing between msdb and master. But I checked the certificates and they were identical....

Just had this same question on another thread with a trigger and doing a large insert...almost verbatim from the other thread:

One thing I can say is that if you were...

These are the two indexes involved in the deadlock:

CREATE UNIQUE CLUSTERED INDEX [CI_Patient_PracticeID_PatientID] ON [dbo].[Patient]

(

[PracticeID] ASC,

[PatientID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY...

I still don't think we have seen the code for object 1945422350.