Thanks but somehow i dont see any instance under my registry. it shows only as

HEY_Local_Machine\Software\Microsoft\Microsoft SQL Server\80. any idea where i am going wrong??

Awesome . Thanks for the help...

Thanks thats  great, but I am looking fro something that can be run from database side only like a sql procedure or so. anyone else have any script for this....

Sorry i am a bit confused now. Ours is a transactional replication. and both at publisher and subscriber we have  " not for replication" turned on. Is it  correct or...

Does that mean it overrides the property of Not for Replication when turned on that column which has a PK. then whats the use of not for replication.

Yes i do understand not for replication is only for identity columns and i do have ID set as identity column . I dont want it to be updated at subscriber...

Yes i am, as i checked the count(*) of rows for few tables which existed on both source and destination and they looked more or less the same. ANy other...

Yes theres only 1 table on thsi filegroup on both sourec and destination. I am trying a dbcc updateusage to see if that makes any difference.

any other thoughts/ideas??

Surprisingly the source server (in replication) has more rows but space usage is more on destination server. also can you please explain a bit more on

"if queue updates are...

My whole point of the question is i know how to create a cursor for checking servers but beacuse an insert happens within a ditributed transaction it fails. any solution...

Thats how the database is designed initially. query works fine but not for last 2 rows how can those be updated if data matches in both tables.

I dont have awe enabled on node 1. The 2nd instance of sql is installed only coupel of days ago so has only teh system database nothing else running on...

But heer i am trying to figure out why this happened and how can i check for this?

We do have transactional replication but we have done this manual deletion a few times before too. and this is happeneing to one specific table only. Since its pretty likely...

Or does anyone have a script that connects thru all servers (also the once not registered in EM)?

TIA