In Enterprse Manger right-click on the Replication\Publications folder and select "New Publication...". Select "Next", any database, transactional publication/"Next","Next".
In the "Specify Articles" screen select "Article Defaults..." and "Table Articles/"OK" to get to the "Default Table Article Properties" screen.
On the "Commands" tab when replacing any of the 3 commands (INSERT, UPDATE and/or DELETE) with a stored procedure call, whatever you enter does not get saved or passed to the "Table Articles" screen for any table that you want to publish. You have to go i
n to each individual table articles property screen to modify the defaults.
Is this a bug or is there something else that you have to do to save the article defaults?
Hi,
Thanks for using Newsgroup.
From your descriptions, I understood that even you have change the SP name
in Default Article, Default SP name will still be created and you have to
change them individually.Have I understood you? If there is anything I
misunderstood, please feel free to let me konw
Based on my knowledge, it is a known issue for us and it is by design. From
Books Online, we could find the descriptions like this:
"Specify that no action will be taken at any Subscriber. Transactions of
that type are not replicated. For example, if you select Replace DELETE
statements with this stored procedure and enter NONE, DELETE statements are
not replicated for that article."
If you UNCHECK the "Use SP" option, then updates are made using TSQL
commands
instead of SP. To not replicate use keword NONE.
I am sorry for the inconvenience you may meet and thank you for your
patience and cooperation. If you have any questions or concerns, don't
hesitate to let me know.
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||Michael,
Thank you for your timely response.
Yes you understand me correctly, and if I understand you it means that I have to change the SP settings on each individual article and setting the defaults really doesn't do anything.
I may have close to 200+ articles that need to have the same settings and from what you are saying I will have to change all 200+ of them when I should be able to set the default and have that setting propagate to the other articles.
Is there a patch or hotfix that I can apply to fix this?
Is this an issue that I should raise as a service call to Microsoft?
I can’t to believe that this problem is listed as “functions as designed”; it just doesn’t work.
Thanks,
Keith B
|||Hi Keith,
I am sorry for the inconvenience you may meet, However, as I have said, it
is an known issue by desing and I don't think we will give hotfix pr patch
for that.
However, I think there is a more complicated one as a workaround. You could
try to use T-SQL statements make a replication. You should create a
replication scripts and then add what you need manually, which I think is
more complex than SQL Server Enterprise Manager. More detailed information
for this could be found at:
Scripting Replication
http://msdn.microsoft.com/library/de...us/replsql/rep
limpl_9sby.asp
Replication Stored Procedures
http://msdn.microsoft.com/library/de...us/tsqlref/ts_
sp_repl_6vad.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know.
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||Hi Keith,
I am so sorry for the inconvience you may meet again
I'd recommend that you forward the recommendation to the Microsoft Wish
Program:
Microsoft offers several ways for you to send comments or suggestions about
Microsoft products. If you have suggestions for product enhancements that
you would like to see in future versions of Microsoft products, please
contact us using one of the methods listed later in this article.
Let us know how we can improve our products. Product Enhancement
suggestions can include:
Improvements on existing products.
Suggestions for additional features.
Ways to make products easier to use.
All product enhancement suggestions received become the sole property of
Microsoft. Should a suggestion be implemented, Microsoft is under no
obligation to provide compensation.
World Wide Web - To send a comment or suggestion via the Web, use one of
the following methods:
In Internet Explorer 6, click Send Feedback on the Help menu and then click
the link in the Product Suggestion section of the page that appears.
In Windows XP, click Help and Support on the Start menu. Click Send your
feedback to Microsoft, and then fill out the Product Suggestion page that
appears.
Visit the following Microsoft Web site:
http://www.microsoft.com/ms.htm
Click Microsoft.com Guide in the upper-right corner of the page and then
click Contact Us . Click the link in the Product Suggestion section of the
page that appears.
Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.
E-mail - To send comments or suggestions via e-mail, use the following
Microsoft Wish Program e-mail address, mswish@.microsoft.com.
FAX - To send comments or suggestions via FAX, use the following Microsoft
FAX number, (425) 936-7329.
NOTE : Address the FAX to the attention of the Microsoft Wish Program.
US Mail - To send comments or suggestions via US Mail, use the following
Microsoft mailing address:
Microsoft Corporation
Attn. Microsoft Wish Program
One Microsoft Way
Redmond, WA 98052-6399
MORE INFORMATION
Each product suggestion is read by a member of our product feedback team,
classified for easy access, and routed to the product or service team to
drive Microsoft product and/or service improvements. Because we receive an
abundance of suggestions (over 69,000 suggestions a year!) we can't
guarantee that each request makes it into a final product or service. But
we can tell you that each suggestion has been received and is being
reviewed by the team that is most capable of addressing it.
All product or service suggestions received become the sole property of
Microsoft. Should a suggestion be implemented, Microsoft is under no
obligation to provide compensation.
Thank you for your patience and cooperation again. If you have any
questions or concerns, don't hesitate to let me know.
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
No comments:
Post a Comment