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 |
|
Milo Cold
Starting Member
14 Posts |
 Posted - 2005-06-02 : 12:09:16
|
| Gretting,So I'm checking out all the stored procedures (SPs) produced by after successfully completing a pull subscription. What I need to do is add a few lines of TSQL so that prior to attempting an INSERT it'll verfiy that it's not already in the table. I could do it for each individual SP but I'm just curious if another method exists.The overall goal here is this: I have a table with two columns (one PK),The application we use basically inserts a new record if the PK isn't found but it updates the non-PK column if a match is discovered. When this table is part of a publication it seems like non of the update default SPs are ran, only the INSERT SPs. So the violation pops up in the distribution agent.If anyone could help me find a solution, I'd greatly appreciate it!ThanksM.Cold |
|
|
|
|
|
Adding Statements to Stored Procedures made by Rep