Thanks Theo; I really need to test that myself , as I clearly don't make enough triggers; I should have known that...i assumed that the tables would only be populated...

as i remember it, parameters may not be constructed inline; they have to be built and then passed:

exec @res = sp_OASetProperty @oMail, 'TextBody', 'This is a reminder to let you...

pretty sure this is what happened:

somebody ran this command:

--Turn system object marking on

EXEC master.dbo.sp_MS_upd_sysobj_category 1

after that is run, all commands that create objects in SQL 2000 are system objects. this...

here's something i use, and i'm sure i'm stating the obvious and what you already did tog et back up and running, but you'd be best off doing a back...

SET @execSQL = 'DECLARE @BeforeValue sql_variant, @AfterValue sql_variant '+

'SELECT @BeforeValue = D.['+@ColumnName+'], '+

...

Jeff I feel really bad...

unless you have the database recovery Model property set to Full instead of Simple, there is no way to determine this without adding features yourself.

if the database is set to...

ok how about this:

get all the tables in FK hierarchy order; truncate tables with no FK, and for teh rest of the tables that feature foreign keys delete ...

it's just an expansion on the first...you have to join Contacts a second time...to do that, you must ALIAS at least one of the contact table references:

SELECT Stage3.Stage3ld, Issues.IssueDesc, C1.FirstName...

something like this will work, if you still need to send one email for each @taker AND each Taker's commisionless order;

if you want to roll them you'd need to group...

if you have a foreign key reference, it's good practice to use the actual column name from the parent table, instead of an alias.

you never mentioned what the relationships are,...

download SQLRecon from sqlRecon.com

it will survey your network and report a LOT of valuable information about all the servers it finds;

chances are it will find development servers you didn't know...

i should have explained...that is not for a trigger!

run that in QA...it should find the sample record you said you created.

if it works, then you can throw away the trigger,...

ok try this: i think the sql below will find everything that has a zero commission, all in one shot.

fromt here, you could construct a single email, or a bunch...

ok here's my idea:

there's a statement that gets this value:

SELECT @Commission = min(commission_cost)

FROM oe_line

WHERE order_no = @OrderNo

i'm thinking that the lines here get inserted into the table oe_line AFTER the...