Let me know if your ever learn the answer to your "Why?" question. I have been wondering this for 7 years now.

Either print the @query value from your SSIS task or else insert it into a table, before the attempted EXEC. Then cut and paste it here.

You cannot just drop raw XML into a forum post. Either wrap it in [ code ] tags or attach it as a txt or zip file.

Duplicate posting. Please do not cross post, it just serves to annoy us.

Please continue at this address: http://www.sqlservercentral.com/Forums/Topic680016-1291-1.aspx

Here is how I would do it (untested):

CREATE TRIGGER dml_TriggerEmail ON Visit

FOR UPDATE

AS

-- Setup e-mail variables

DECLARE @EmailSubject VARCHAR(200)

SET @EmailSubject = 'Email Boss'

IF UPDATE (DeptApproval)

BEGIN--The column was SET in the...

No, COLUMNS_UPDATED works the same way, it just combines all of the columns into a single bit pattern. MS cannot give us a function like you want because there...

Good stuff both ways, Florian.

Though in SQL 2005 you are probably better off using the XML data type and methods.

Oops! Right you are...

That's...

Actually, I am going to side with Foxjazz on this. There are a number...

Patience. Most of us have too much pride to swallow it all at...

GilaMonster (3/19/2009)

---

kevin77 (3/19/2009)

---

The solution to solving SQL Injection attacks is simply for every RDBMS system to flat out not allow inline SQL. Everything must be done with stored procedures...

I see some discrepancy: you say they are close if Diff<=2, but the comments imply that Close is Diff<=1?

I ask because testing for Diff<=1 is pretty easy to do.

Bob: Whats the scoring criteria that you are using?