Melissa... thank you very much for your answer.  Thanks for letter me know that I'm on the right track too.  Glad to hear you are doing merge replication on similar...

I'm also new to replication, but the way I see it, you would use 1 database, Test1 and you would do a merge replication so that the database was on...

Yes, it is a little big.

I did finally extend some of the Agent Profile settings and got it to make the snap shot (the problem was with making it, not...

A merge publication can be updated at two or more locations and could be the answer to your problem.  Your applications will need to support it though.

I am having a similar problems with new configured cluster (Active/Active configuration). During each installation of SQL 2000 I specified installing TCP/IP only. One on of the virtual...

Thank you thank you...

I ended up using:

Right('00' + CONVERT(VARCHAR, table.version),2) AS version

and it worked as advertised.

Andy, thanks for taking the time to reply. I had to change my thinking a bit when I started using them, but once I did, the sorting didn't matter...

Sorry, I was a little active on the "Post New Reply" button before.

I found in BOL the sp_dboption to put the db in Single User mode, trying to...

Ok, so far so good. Now I understand the message and I read up in BOL about DBCC Checktable. I ran the command and got:

"Repair statement not processed....

Ok, so far so good. Now I understand the message and I read up in BOL about DBCC Checktable. I ran the command and got:

"Repair statement not processed....

Ok, so far so good. Now I understand the message and I read up in BOL about DBCC Checktable. I ran the command and got:

"Repair statement not processed....