sp_register_custom_scripting - has anyone used this for their custom procs?

  • 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.

  • 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.


    Have Fun!
    Ronzo

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply