Thanks Jeff...

Hi Nandhalal,

You are absolutely correct, if the table does not have Primary Key than that table will not be replicated in transaction replication.

You have to define Primary Key on each...

Hi Smith,

Thanks for your reply.

But I had already upgraded my database to 2005 (by backup and restore process). In this excercise compatibility level remains on 80. Now, I want to...

Thanks Roy!!!

Thanks Preethi !!!

Thanks Jason for your inputs!!!

But I want to switch it permanently and would like to know what are the after affects. Some of my codes stopped functioning or there is...

Is that so easy to switch the compatibility level from 80 to 90 and then revert back the settings? Is that so easy?

I also want to switch the database compatibility...

Hi all,

I have restored my SQL 2000 database onto SQL 2005 with the compatibility level remain 80. Now, I would like to switch the compatibility level fro 80 to 90...

Hi all,

I have restored my SQL 2000 database onto SQL 2005 with the compatibility level remain 80. Now, I would like to switch the compatibility level fro 80 to 90...

Yes, if the views and SPs are not so frequently changed/modified then transactional replication is the best solution to replicate the modified data (in tables) from the production server to...