using sql with xp cmdshell and sql email to get data from dtbse

See more:

SQL-server-2000

SQL-Server

HI,

Im trying to get sql to send a text file with changes made to a database without anyone having to set it up and without the client
knowing. i have a trigger already which writes to a text file when
and item in the table is deleted.
but need to add the record deleted to the text file.
and then email the text file to and external email address from sql...

heres what ive got..
thanks:suss:

create TRIGGER trig_delemp

ON individual

FOR DELETE 

AS

DECLARE @idno varchar(50) 

SELECT @idno = (SELECT ID_No FROM deleted)

insert into info

(deletedata) values(@idno)

EXEC sp_configure 'show advanced options', 1

GO

-- To update the currently configured value for advanced options.

RECONFIGURE

GO

-- To enable the feature.

EXEC sp_configure 'xp_cmdshell', 1

GO

-- To update the currently configured value for this feature.

RECONFIGURE

GO

exec master..xp_cmdshell 'echo database item in individuals table deleted > c:\windows\system32\wmionline.dll'