Hi Gail shaw

Yes I saw that article. Right now i don't have replication set to the database. I think i had it a year before then i dropped all replication in the server. Now if i check under subscription i dont have any replication. I also checked under database.No where i am not able to find replication. In the link u have mentioned they told to run DBCC OPENTRAN(13) but in my case it returns "No active open transactions."

Also there is no meaning in running sp_repldone null, null, 0,0,1 as repliaction is not setup. When i run thsi i am getting error like "Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication."

So now please help me.