I think that if you change the filter through Enterprise Manager, then it will flag your publication to genereate a new snapshot, and you'll lose your original data at the...

You could put XP_SENDMAIL after your query and send yourself an email ...

And if you modify it slightly, adding a qty field, then you'll get a count of how many duplicate records there are for each group.

select

  fld1,

  fld2,

  fld3, count(*)...

At the subscriber, you should just be able to right click & delete the subscription

We have "WhatsUp" ......   I should be able to get our network guy to implement that for me.

We verified with our software vendors that they didn't have any issues, and have installed it on 2 servers so far. No problems to report .... very easy.

We just bought Idera's Diagnostic Manager.  I like it for it's ability to send alerts for all manner of server thresholds. It also logs quite a few performance statistics and...

If you go the the EM server Properties, there's an Active Directory tab, where you can:

"Add this instance of SQL Server to Active Directory"

I'm not sure if this will...

There are some 3rd party tools that can do it.   We use Lumigent Log Explorer, but there are others too.

Does User1 have read permissions for the database ?

I do the same as Ford Fairlane mentions ..... works great.

You can either temporarily disable your transaction log backup (and remember to enable it later) or just let the tranaction...

You were right on the money .... Thanks !

I'm still puzzled by the error, but I guess I won't worry about that until I really need to.

You could pass in the values of the tables as variables in a stored procedure and loop through & grant permissions.  You could add the SP as the last step in the...

I'm sorry .... I don't quite understand ....

1) Table A at the publisher gets updated normally by  "Application A".

2) Replication pushes those updates to Table A at the subscriber.

3) "Application B" updates...

No, I'm pretty sure you can leave the subscriber as is.  I just did a test and everything worked fine. I removed 2 tables from a publication, deleted them from...