pgomes (2/10/2009)

---

My question is: how many rows are created in the inserted and deleted tables for a script like above that update more than one column, for the same primary...

Just do a second RECEIVE in the activation procedure.

All it does is to insure that at least one non-key column is not null.

update TableA

...

from TableA left join TableB

on

(TableA.key = TableB.key)

...

where

(TableB.key is not null)

...

I think that these things cancel each other out. Try this instead:

update...

Oh I think that you're right, Andy. I wasn't trying to be critical, I just happened to have the 2008 version open at the time, so I tried it...

Definitely. Everytime I was at a different customer site and scripted a database, I would see something that I hadn't...

Checkout the SELECT statement's "TOP (X)" clause in Books Online.

Ninja's_RGR'us (2/7/2009)

---

RBarryYoung (2/6/2009)

---

Lowell (2/6/2009)

---

i've got a stored proc i made that i named sp_getDDL, which trolls thru the table definition and it's columns and builds the script for the...

Lowell (2/6/2009)

---

i've got a stored proc i made that i named sp_getDDL, which trolls thru the table definition and it's columns and builds the script for the table; it's...

Jack Corbett (2/6/2009)

---

RBarryYoung (2/6/2009)

---

Nice article, Andy. I tried this on SS2k8 and one thing that surprised me was a number of small details that changed and threw me first:...

Note that even if the table were still around, it would still be extremely difficult to get exactly what the OP is asking for. This is because SQL Server...

Nice article, Andy. I tried this on SS2k8 and one thing that surprised me was a number of small details that changed and threw me first: Like "Dts.Results.Success"...

Thanks, Gaby. Yeah, schema are the missing piece in a lot of the nicer scripts and tools for SQL Server. things changed so much from 2000 to 2005...

Jonathan: which is the part that cannot be done? Just the Bitmap stuff or do you mean anything from System.Drawing.dll?

I believe that you have to explicitly catalogue System.Drawing.dll as UNSAFE in order to get it into SQL.