January 11, 2008 at 2:03 am
Seems an excellent way to control your custom procs but there's little documentation. Just wondered if people use this out there, and if there are any pitfalls or guidelines..
As documented in:
http://technet.microsoft.com/en-us/library/ms188010.aspx
Regards
Rob.
July 7, 2010 at 2:44 pm
Yup, use them extensively. The biggest pitfall encountered so far is a bug introduced in SQL 2008 that causes non-dbo schema procedures to be created with a prefix of [dbo]. Simple work-around to directly update the sysarticles table entries.
Otherwise they've been great. The automatic regeneration on schema changes is a big benefit. And having a single central stored procedure that generates hundreds of customized versions for each article is fantastic.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy