I can send the result of a query as attachement to an e-mail message by running the following script:
EXEC xp_sendmail @recipients = 'chadi',
@query = 'SELECT * FROM Vmdb2..Customers',
@subject = 'Customers',
@message = 'The contents of Customers',
@attach_results = 'TRUE', @width...
Is it possible to use sp_processmail procedure to send replication's data between 2 servers. At the moment, I can replicate 2 sql servers over the network. What I need is to send replication's files from one server to the other through e-mail.
I need some information about sending the result...
I need to know if Replication between to SQL Servers can be done through e-mails. e.g. Sending replication files through Microsoft Exchange Server.
Regards,
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.