October 1, 2007 at 4:27 am
In Andy Warren recent replication article (http://www.sqlservercentral.com/articles/Replication/3202/)
, sp_scriptdynamicupdateproc , is discussed, but I am not sure how this procedure, sp_scriptdynamicupdateproc , is used, it won't parse for me. Can you give an example of it beign called please?
"There is one other option for updates, but you won't find it in the UI. You can run sp_scriptdynamicupdateproc to generate a stored procedure that will build and execute dynamic SQL on the subscriber. Running the procedure just generates the script, it is up to you to apply it to all of your subscribers. The tradeoff when using this is that you only touch truly changed columns which may increase performance if many of the columns are indexed, in return you incur the overhead of building the statement and executing it each time. Here's what we what we would get from our original test table after running the proc on the publisher"
October 1, 2007 at 3:21 pm
... I am not sure how this procedure, sp_scriptdynamicupdateproc , is used, it won't parse for me ...
Why are you saying that it won't parse ? Is this happening when you copy+paste and run at subscriber ?
* Noel
October 2, 2007 at 2:25 am
yes, in a query window I paste in, sp_scriptdynamicupdateproc, and it cannot find the procedure.
October 3, 2007 at 6:33 am
The procedure is sp_scriptdynamicupdproc. not ...updateproc.
October 5, 2007 at 12:42 pm
Jeff Gray (10/3/2007)
The procedure is sp_scriptdynamicupdproc. not ...updateproc.
great catch. Sometimes we don't see the forest for the trees ... 😀
* Noel
October 8, 2007 at 1:26 am
Many thanks!
Has anyone used the sp_changepublication to include a post snapshot script to include these updated procedure definitions? And do you know if it's OK to run sp_changepublication on an exsiting publication without it affecting the current subscribers?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply