we are using BMC's Patrol - Sybase and SQL 7/2000.

Great product.

silly mistake. Named Pipes vs. TCP/IP. All set.

Thanks for the help!

I am using a SQL login... 'sa'. I'll try the ODBC trick.

Thanks.

Thanks for the help guys... I will try both.

not much... normally under 10 meg. There are data feeds throughout the day that may be a little larger.

Sean - 1/2 hour latency is the spec right now.

The primary purpose is failover but I wouldn't want to rule out reporting or other read only access.

Thanks again.

Thanks Andy.

2 more questions.

Does SQL Server 7 support log shipping? If so, does it work?

In a nutshell what are the pros and cons?

I guess that's 3 questions...sorry.

I am able to open the .mdb without a PW using Access. I did try to use the'admin' login but it still did not work. I haven't tried the compact...