GilaMonster (4/12/2012)

---

I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing code segments together at random...

Lowell (4/12/2012)

---

the trigger has no WHERE statement, and never references inserted or joins to the remote table...does that remote table only have one row?

is there a realtionship between teh...

capn.hector (4/12/2012)

---

Lynn Pettis (4/12/2012)

---

drew.allen (4/12/2012)

---

I've come to the conclusion that he's not really interested in answers. He's...

GSquared (4/12/2012)

---

Eugene Elutin (4/12/2012)

---

...

It's entirely possible someone with better C#/VB.NET skill than mine can make a CLR function that's faster, but the options I found online for that were...

drew.allen (4/12/2012)

---

I've come to the conclusion that he's not really interested in answers. He's only interested in...

Any triggers on the other table? If so, could you post it also?

How wide (number of characters)? How much wider with the new column? Were you adding the column at the end?

What would happen here on SSC if the TOP 25 posters did nothing but lurk for 24 hours?

Any error messages? If so, the complete error message(s) would be helpful.

Yes, post the definitions. We can't answer your question(s) when we can't see what you see.

Looks like it was adding at least 2GB of space when adding the column. How big is the table (rows) you were trying to add the column?

Read the first article I reference below in my signature block.

eric.lyons (4/12/2012)

---

First step should always be to use explain plan to look for table scans, among other things. That would usually indicate a missing index, a bad join, etc...

You've...

Close the two I mentioned when younger were actually K2 and K3. My oldest daughter was K1. The first names of all three of my daughters start with...

Off hand, nope. You might want to check Books Online to see of any...