I need to delete a transactional publication (no subscribers) and the
associated database.  I have tried to use sp_droppublication and
sp_replicationdboption without success and I believe that this is due to some
of the conflict tables being deleted from the published database.

Nearly 100 tables are in merge replication and I need to remove 5 tables
from replication.  
Is it possible? If so what are the steps I have to follow?
Please advise.

I am developing a transactional replication plan.  I have one table
that most of the time I do not want to replicate deletions.  There is
an exception to this rule.  If the status_id of another table is false,
then the deletion should be replicated.

I have a problem with one of my publishers. When I click on the "Articles"
tab under the "Publication Properties", I see all my articles but everything
is greyed out. I can't uncheck any of the articles and I cannot add any. I
need to add one more article to the publication!

Hi Guys,  I have recently removed replication from the SQL server (2k)
and everything seemed to be working at first.  Initially, the database
still contained all the conflict tables etc... but I got rid of all
those.  However, now, when attempting to insert into some tables in ...

SQL 2000 trans replication.
I have a fat table (100+ columns ) being replicated minus a couple columns. .
How do I query the replication sys tables to find all columns being
replicated? Goal is to find which columns are NOT replicated.

I have an application that has been using a right outer join that worked as I
expected until I added merge replication. On the replicated database the
result is the same as an inner join. I could be doing something odd but it's
a pretty plain use and it still works on instances ...

I have a SQL 7 database who's log is growing and cannot be truncated. It is a
copy of a database from another environment and is involved in Transactional
Replication.
When I try to run sp_repldone, it says the database is not published (which

I have implemented a transactional replication (queued updating) that
creates a full replica of the main database. The size of the main db is 15GB
and the replicated db's size is 12GB. I would like to know why this
difference.

After installing SP4 on distrib and publisher (subscr SP3)
on one article in merge publ a problem of bitmap occurs when updating one
column on subscriber :
i updated col44 of the table on subscriber, i saw on trace that the repli

Just completed the transactional replication and when tried to test the
changes made in the publisher data it (Distribution Agent) failed with the
following error:
-----------------------------------------------------------------

How can I get a list of all the triggers associated with a particular
table in a database. And in addition, how can I get a list of all
triggers for the entire database (meaning all triggers associated with
all tables)?  Thanks!!

I have more than 500 databases on my sql server 2000 enterprise edition. I
have already suffered the deadlock problem mentioned in
http://support.microsoft.com/kb/246330
So, I tried to upgrade to sql server 2005 but still unable to implement

Hi I'm trying to setup a push replication between 2 servers on different
networks. both machines can ping eachother using there machine names. I setup
the publication and the distributor on the push server and generate a
snapshot. I then run the distributor but it fails to ...

Is there a way to add the "Not for replication" switch for triggers and
foreign keys other then dropping and adding them again?
Thanks in advance,
Pauly C