I looked there and didn't find it. Don't see SQL Server Project either.

OK - I've got it now but unfortunately, I haven't got an answer for it.

I may not be understanding the scenario correctly. It looked like Track2 is basically a standby for Track1. I beleive you can do Transactional Repl  to it and that should...

Make Track1 a re-publisher and Track2 its' subscriber.

It sounds like the distribution agent is scheduled and you may need to shorten the period between runs or change to continuous distribution. Continuous distribution would provide the least latency...

No - EM in 2K used replaceable parameters. [SRV] would be replaced by the server name currently selected in the list of SQL Servers. I was hoping to di the...

How are you entering the arguments. All I seem to be to see is my own  C drive.

try looking here: http://www.sqlis.com

Another thought - why not set the variable @body = <query>?

I don't know much about OA but there is a script about SMTP mail here: http://www.sqlservercentral.com/scripts/contributions/510.asp

Maybe there is something in it that will help.

I really don't know. I've not replicated views, I just know that they can be replicated. I would venture a guess at the data winding up in the base tables but...

Views can be replicated so why not create a view witht the parent/child rows in it.

See this link:

http://www.sqldts.com/default.aspx?304,1

it shows how to use the FSO to find files in a folder and pass the names to a package.

thanks for the response but from what I see, the documentation seems to apply only to the initial installation of SQL Server. 

I did a manual installation on a server and...

Thanks -  I did find that SQL 2000 supports it in a non-clustered environment (which I wasn't aware of) and 2005 adds clusters.