it seems that u don't require the space actually. Then y are you trying to reclaim the space ? additionally if you really wanted to reclaim it you should have...

Paul/Dev i am waiting here for your responses

Do we also require to stop Log reader agent, Snapshot Agent and Distribution Agents for any database from where we are removing publication ?

Thanks Paul and Dev.but frankly telling i did read this article earlier also but practice or implementation giving more clearance here 🙂

i got the solution to "switch partitioning option"...

Thanks Paul for your quick help.

but i got one more concern.

first can below query will get replicated to another node (from server A to server B in P2P...

Can you please explain the table "Select * from MSpeer_lsns"

data from above query on server A

idlast_updatedoriginatororiginator_dboriginator_publicationoriginator_publication_idoriginator_db_versionoriginator_lsnoriginator_versionoriginator_id

12012-01-16 13:30:33.523INBKUMAR02\SQL2008R2CVENT_DM70DM701-10249085220x000000EF00000D9200011710505601

32012-01-16 14:16:52.083INKMEHTANI02\SQL2008R2CVENT_DM70CVENT_DM701-4374076480x001710505602

22012-01-16 13:40:37.847INKMEHTANI02\SQL2008R2CVENT_DM70DM7019609388030x000000EF0000068900041710505602

data from above query on server B

idlast_updatedoriginatororiginator_dboriginator_publicationoriginator_publication_idoriginator_db_versionoriginator_lsnoriginator_versionoriginator_id

12012-01-16 19:06:13.110INBKUMAR02\SQL2008R2CVENT_DM70CVENT_DM701-10249085220x001710505601

22012-01-16 19:21:33.477INKMEHTANI02\SQL2008R2CVENT_DM70CVENT_DM701-4374076480x000000F20000013000161710505602

Please give advice from...

Thanks divine but seconds error is still there .

i got succeeds to implement it but following error now i got

while inserting from server A to B

Error messages:

A conflict of type 'Insert-Insert' was detected at peer 1 between...

Here i am talking about Peer to peer replication 🙂

we are using transactional replication, no data in this(your) query 🙁

...

Error logs doesnt show any thing.can you tell me DMvs , i can use ?

NO... we have different account setting on both servers.

Additionally , i have UAC enabled with second stop option (from top)

@rafi,

i would say , if dedicated Sql team is not possible then you can ask for some sql skilled resources who can assist the developers in

complex sql writing

tuning and...

If the changes are at schema level then those can be traced with the help of DDL trigger. but neither Gail nor GSquared mentioned it.

Did i overlook something in...

@ashish,

go to services.msc and check have you selected the "manual" option ?