Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-10-08 : 05:07:59
|
| Hello ,I have created a publication from SQL Server 7.0 and subscribed the publication it to one of the SQL 2000 server std. edition . Now there are some entries in the subscription list at the subscriber which need to be deleted . The list shows the name of the publication , the database name and the date . I wanted to know hoe can we delete those unwanted entries. If i select the entry and right click on it , there is no delete option . Are those entries to be deleted from one of the tables at the subscriber or the publisher ? If yes, then what is the name of the table ? Any ideas ?Thank you very much . |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-08 : 12:45:08
|
| You can filter out rows from a publication. Do these unwanted entrees have something in common? IE : a filed name entry type and when it's 4 we don't want it? If theres no consistant pattern to which rows you want to remove and which rows you want to keep, this could be challenging.-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
|
|
|
Deleting unwanted entries at the subscriber .