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 |
|
acyu0318
Starting Member
1 Post |
 Posted - 2004-11-01 : 17:47:15
|
| I have been asked to add a new article to an established transactional replication. I add the new article through query analyzer with the sample script provided from microsoft website.<code>EXEC sp_addarticle @publication = N'Static Set', @article = N'ACTION', @source_owner = N'dbo', @source_object = N'ACTION', @destination_table = N'ACTION', @type = N'logbased', @creation_script = null, @description = null, @pre_creation_cmd = N'drop', @schema_option = 0x00000000000000F3, @status = 16, @vertical_partition = N'false', @ins_cmd = N'CALL sp_MSins_ACTION', @del_cmd = N'CALL sp_MSdel_ACTION', @upd_cmd = N'MCALL sp_MSupd_ACTION', @filter = null, @sync_object = null, @auto_identity_range = N'false'</code>I was under the impression that by running the script above the insert, update and delete command will be automatically created by SQL Server for me, however, that doesn't seems to be the case. Did I miss something, or should I change the schema_option to other value in order to accomplish autogenerating the insert, update and delete stored procedure?Any help is appreciated. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-01 : 22:58:43
|
| since most of the values for the parameters are default, can you just:EXEC sp_addarticle@publication = N'Static Set',@article = N'ACTION',@source_owner = N'dbo',@source_object = N'ACTION',@destination_table = N'ACTION'then post whatever errors you get...--------------------keeping it simple... |
 |
|
|
|
|
|
|
|
sp_addarticle and @ins_cmd, @del_cmd, @upd_cmd