wow just some wild guesses here, no idea if it is right:

i'm assuming ticks means what i found on my search internet search:

declare @ticks bigint = 624511296000000000;

--One Tick is 10...

i can find it on Amazon.com, and through them, lots of various retailers, but i think that implies a US purchase.

additionally, i'm not sure how many processors that includes for...

the trigger always fires every time, it's just it...

easiest way is to use bcp.exe to a CSV file, which by default opens in Excel on most peoples machines.

if you want a single document, with three worksheets, you'll...

basically, we are updating the current table from INSERTED, so...

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