take a look at teh script mister magoo built in this similar barcode 128b thread:

http://www.sqlservercentral.com/Forums/Topic1470917-392-1.aspx

with that and a bar code font, i think you would have everything you need

your trigger is very close;

inside a trigger, isntead of using @@identity, you wnat to use the virtual tables INSERTED (or DELETED, where approriate);

that virtual table allows oyu to handle multiple...

i would disagree that restoring system databases is going to save you any work.

I personally prefer to script out things like certificates, master keys, linked servers and logins, and jobs...

i have a big proof of concept CLR project that is filled with items i either create myself, or find here on SSC.

I just keep adding to it as I...

glad i could help; it's so much easier to take an example and adapt!

enjoy!

there are dozens of scripts here on SSC for scripting out jobs:

http://www.sqlservercentral.com/search/?q=script+jobs&t=s

so from there you could then add a WHERE filter to any of those to limit to a...

i know i could do it via TSQL, with two separate queries.

you could use a FOR XML to generate an html compatible BODY and a separate query for the sp_send_dbmail's...

um, no.

your if statement makes the trigger no longer support multiple rows.

if i have, say five rows being updated, what row is this supposed to test?

IF INSERTED.review = 0

a great...

margrests example returns a lot of false matches, becasue'ca' appears in a large number of values int hat string. searching for comma-space-CA was really the oinly way to do it...

performance typically has a lot more to do with

1. the sarg-ability of the queries hitting the database,

2. the accuracy of the statistics on the data and

3. the...

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...