ahh you are right Greg, i did not notice that. Thanks for the better solution.

the trigger fires one for any statement which affects the table; as a result, any statement you write inside that trigger must plan on updating/inserting multiple rows. it CANNOT assume...

ok here's a best guess;

the execution plan has a portion of the query in it..something like the first 4200 characters or so, so i didn't have all the joins...i inveted...

##Errors is a global temp table...the two pound signs make that global instead of just for your proc.

a global temp table is visible to all other processes that might need...

lol:

i saw that too, and was wondering...

save it as a SQLplan...that's just xml. you can throw it in a zip file , and then attach it here to a followup post.

when we open it in SSMS,...

Rob SQL2008 has an actual CPU governor for that situation...preventing any one query frome ating all resources...it's not in 2005.

a 20 minute query is unusual, unless you are threshing thru...

ahh you changed it on me since i posted....

i would switch tou using the row number function then...see how this works for you.

run the inner query so you can see...

way to go on posting the table and data! it made it really easy to try and help!

here's two examples; in one i figured you jsut wanted the ID, and...

the typical "it depends";

I'd take into consideration whether there is a possibility that the blobs would be one-to-many for the main record. even if "today", you are only capturing...

you'll need to change your encrypted column to a varbinary. I believe the rule is if you are doing a 19 char field, the size for the varbinary is twice...

i contributed that script a while ago, and clearly it's only for SQL 2000;

here's someone elses script that I saved in my snippets that does INCLUDE columns;it does PRINT statements...

if they are doing the setup, figure out which tables you will be using, and get them to add synonyms for those tables as well...it really makes your sqls cleaner:

IF...

there's a thread on the new updated codeing somewhere, but i happened to keep the list handy in my snippets:

note that there's a space between the bracket and "code" so...

here's the syntax and example of adding a linked server for an access database, the login for it, viewing the list of tables, selecting from one, and finally updating one...