sql server replication: Hi,

I tried to implement Snapshot replication and collected all the test
results. Finally dropped all the replication stuff from server,but the host
DB is still showing as "Shared" and i need help to remove this.Not sure how
to proceed. Any help will be great.

Thanks,

Please try this:

USE master
EXEC sp_dboption 'yourdatabasename', 'published', 'FALSE'

HTH,