Ok, so there are some problems with the code that need addressing.

First, the patterns : they will not work with PATINDEX, also we need to know the length of the...

Good news...

Have a look in your user temp folder (Start...Run...%TEMP%...OK) it may be there named ~vsXXXX.sql where XXXX is a number...

SSMSTools is worth installing for this feature alone - it records...

I don't use the redgate ones but have had issues with other add-ins and biggish union queries... although they were quickly resolved by the authors

Do you have any add-ins installed in SSMS - like maybe a code completion tool?

Good news, glad you found it. And thanks for the feedback.:-)

I would check for database/server level triggers - my guess is you have one that is misbehaving...

You're welcome. These things are sent to test us 🙂

You need to use the Array() function...

Tom.Thomson (2/8/2011)

---

The algorithm posted by Mr Magoo ... (edited for brevity) ... is however an appallingly opaque way of doing something that can be done in a very transparent manner....

Yes, it is probably the best way to go.

Ok, maybe CONTEXT_INFO is confusing the matter....

So, I have created a test script that creates two databases, two tables with two triggers and a third table to act as the...

No problem, thanks for the feedback.

Can you check if the provider option "Level Zero Only" is checked in Server Objects/Linked Server/Providers/SQLNCLI10

If it is checked, it could be the cause of the error - if appropriate...

Here you go ...

This generates a linking column against each table - a simple row number for each user and an NTILE based on count of users for each MITagging...