for individualized emails, i think you'll need two things:

a cursor to go thru the list of email recipients, and which builds the custom subject/body

sp_send_dbmail to actually send the email.

do you...

Thomas no sense reinventing the wheel; it sounds like you want to search for "free work order system" or "free support ticket system" and maybe include "sql" in it to...

dwilliscp (7/26/2013)

---

Great.. how would this work with an insert? Would it execute? If so how would we wrap this in an IF statement to only run when updating the row.....

that extra requirement is easy;

we have to compare the INSERTED row to the DELETED row, and compare in a WHERE statement:

WHERE INSERTED.[Comments] <> DELETED.[Comments]

here's the trigger model again with...

yep, that was because of the construction of your trigger:

the [Document] = (select [Document] FROM INSERTED) would make the old trigger fail if more than one row was updated.

my trigger...

dwilliscp (7/26/2013)

---

The where looks at the two columns that make up the PK... You code is more compact though.

But I am looking for a better way to not run the...

As An FYI for datetime, Luis mentioned you can't add a single millisecond; the minimum is 3 milliseconds, and that's imposed due to the way the data is stored by...

Patti yes, that is correct; we...

my first thought, is that this trigger is checking things that don't make sense in that WHERE statement, and can be updating rows that it should not.

of course the [Document]...

dwilliscp (7/26/2013)

---

Is there any way to limit the trigger, so that it only runs when the app is a .Net SqlClient Data Provider? Or ...not to run if the app...

Patti I hope this helps:

this is a copy of the definition for scripting my linked server to Oracle; this is working for me, without using a DSN.

note that if your...

ok, after modifying the SoapAction to the correct name, i get the xml back of the data table, but the xml doesn't contain the schema,just the data i think,...

||edit||: the code below, as long as you have a web server and a valid conneciton to a sql server from that web server works 100%

I found this interesting when...

note that the PATH variable is null?

I'm sure that means because someone is actively using SQL Profiler to run the trace live; Profiler will instantly recreate the trace if it...

Cadavre I love your new signature with the nolock pointers! just noticed it today.