Its really useful information, its worked fine for me.

1. I deleted subscription as well as publication.

2. when i delete or drop the publication database.

3. i got an error this db is marked for replication so i can't delete this db.

4. after running this sp i.e sp_removedbreplication 'xxxdb'

5. successfuly dropted the xxxdb.

Thanks Noel

-Ratnam