what kind of replication you are using? I have transactional replication here and normally stop the log & distributor agent both but for major break (longer duration) I simply disable...

Thanks Suresh,

You r right on virtualisation that its on server2008 with sqlserver 2008 but what I'm looking for is the drawbacks of sqlserver 2005 over virtual environment (say Windows Server...

I have faced a similar situation where I'm unable to find "sp_MSin_EVENTCATEGORY" with Error number 3701

Any Clue?

regards

Chander Sangra

Thanks John,

What I was doing so far (after consultation with design team) was:Create duplicate table2 with added identity column(dummy), insert into table2 select * from originaltable, marking identity column as...