sql server programming: Sql Server Replication Log file creation -- sql server programming

Sql Server Replication Log file creation

ferozsaiyed NO[at]SPAM gmail.com
8/19/2007 11:05:41 PM

sql server programming: I am working with SQL Server 2000 replication. Replication Occurs
Every One hour, and will updates the master and local servers.

I need a log file to be created with the same file name after every
replication. I have software that will monitor this file.The file is
created in Publisher's Server

If the file is present in the folder, replication has occurred
successfully.

Re: Sql Server Replication Log file creation

David Portas
8/20/2007 7:20:13 AM

[quoted text, click to view]

If your software is monitoring for a file then why not monitor the
replication server via the MS replication system tables or via RMO?

http://msdn2.microsoft.com/en-us/library/ms147926.aspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--