Ian,

I appologize for not giving a better picture of what I want to accomplish. This is a brief description.

The MessageTbl table accumulates messages of different types (type column) from different...

Hello PW,

Thank you for your reply. Do you think that the query you suggested would benefit from any additional indices. I currently do not have any indices in any of...

Hello Steve,

You are correct. I meant rows, not columns. Also, I do not do much when I insert or read a notice from the Notification table. I try to keep...

Thank you for your reply. In my setup, I do not intend to have both

servers activelly transacting with the database. I want both servers

to attach the same database files...

Dear Steve,

With my SAN, I can open and modify the same file concurrently. I think this is what might be tricking SQL Server.

Do you think it would be an issue...

Hello Andy,

I am not using a cluster against my SAN. All my database files, including the master, model, and user database are located in the SAN. I have the same...

Do you know how I can prevent the data to be sent back to the other satelite databases?

Thank you

CD

quote:

---

Merge replication...

Hi Jon,

Thank you very much for your reply.

The 2GB database size limit and the 5 concurrent users under MSDE do not pose a limitation to our application.

It is strange how...

Andy,

We keep the log reader running all the time while replication is going on, except when we shut down replication. Our sequence of steps to clean-up replication are:

1. clean-up the...

Andy,

Thank you for your reply. There is no guarantee if or when the backup server

will be reattached. Therefore, I must completelly stop replication otherwise our transaction log file will...

We already did that but it does not seem to make a difference in the state of the non-replicated transactions.

- CD

quote:

---

Why don't...