Recent content by cdassouk

Thanks a lot for your comments. You are right, how to identify what needs to be sent? Actually, I found that this option is available in Sybase but it is not available in SQL Server. In Sybase you can set up a message based replication that allows replication between 2 databases that have no...

Is it possible to write all data transactions marked for replication in a database to a text file??? Thanks in Advance.

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,

There is one stored procedure in MS SQL7 to add a distributor which is : sp_adddistributor. I need to know if it is possible to add a distributor by using SQL-DMO from Visual Basic rather than calling this stored procedure. Thanks

I want to enable a SQL server 7.0 for replication from within Visual Basic 6.0. How can I do it? Thanks