May 13, 2004 at 1:29 pm
Hello,
Well I did a big no-no. While trying to specify a LARGE subset_filterclause for merge replication I EDITED sp_AddMergeArticle in the master database. Did exec sp_reconfigure 'allow updates',1 and reconfigure with override (totally ignoring the warnings), and made my edit (increasing the parameter from nvarchar(1000) to nvarchar(4000) which is its max.
The problem I have now is that the 'type' is User instead of System. So natually when it runs now it breaks.
So the 64million dollar question is how can I return the type to a system-level proc? (without reinstalling SQL, of course)
Thanks in advance and feeling pretty stupid...
Chris
edit: follow up one big no-no with another... edited proc column in sysobjects *yikes* everything is all set now.
May 13, 2004 at 3:18 pm
Try this:
EXEC sp_MS_marksystemobject 'sp_AddMergeArticle'
Steve
May 13, 2004 at 10:28 pm
I like your way better, thanks!
Chris
May 15, 2004 at 7:42 am
No problem! It was driving me nuts, because I knew it was there, but I was looking for sp_makesys......!
Steve
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply