This is the code:

EXEC master..xp_sendmail @recipients = 'me@meltd.com',

@query = 'SELECT * FROM NewPartNos..PartIDUpdate',

@subject = 'New Part Numbers',

@message = 'The contents of New...

Hi Winash, are you sure it is the @Query argument.  Its just that I get the error message

Invalid object name 'PartUpdate'.

I am going to scrap this and go a completely different route instead.  I will use SQL Agent Jobs.

I will create a Query which will then be executed in a...

Good Thinkin.

I have been asking a few other people and they have come up with this code.

CREATE TRIGGER NewPartIDUpdate ON PartIDUpdateNT

FOR UPDATE

AS

DECLARE @PartID int, @msg varchar(100)

IF UPDATE (GGOPDT)

BEGIN

SELECT...