Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  sending mail from sql server with attachments?

Author  Topic  hameed Starting Member 40 Posts Posted - 2001-07-24 : 08:42:42 This code of http://www.sqlteam.com/item.asp?itemID=5003 is excellent!! Can it be easily modified to be able to include attachments that are created by some bcp script to extract data from a table. I basically want to have a stored procedure that automatically runs itself every night at 12:00 that simply extracts all the data in a particular table by creating a comma delimited text file and then attaches it to an email and sends it to the owner of the site so that they can import it into a local ACT database? When I extract the data, is there any way I can programatically determine the next time I do the extract if new records have been added? Please explain how to do this.