I'm assuming you mean you can have more than one author to a book and you want to show only 1 ?

It would help to have the structure of the...

I try to avoid computed columns..

I'd probably do this as follows:

create table foo_name

(

foo_name_id int identity(1,1) primary key,

foo varchar(100) default 'None',

[Name] varchar(50),

[allocated] bit default 0

)

go

create trigger tr_foo_name_alloc

on foo_name

after update, insert

as

If exists...

Have you tried using xp_sendmail from a sql task ?

Of course this requires that your server have an exchange account set up. I have several jobs that report failure...

I do something like this entirely through a SQL Task..

Just use @@ROWCOUNT, conditional statement, and xp_sendmail.

-- M Kulangara

If I'm understanding you correctly...

1.) Create a connection to your sql server

2.)Create a SQL Task

3.) Past your t-sql code from above in the SQL Task.

Should be easy.

Schedule the DTS package...