Deploy New User Defined Function to Anon Merge Replicas

How do I get a New UDF to propagate to Anonymous Merge Subscribers?
SS2K SP4 Added New UDF <fctrptTeamReview> to Database using Wizard
Tried CREATE in Query Analyzer, then though there might be a Stored
Procedure . . . No joy! Checked BOL, Hilary & Paul
Aubrey Kelley
your options are
1) create a new publication and send it
2) use sp_addscriptexec to deploy it to unc deployed subcribers only (it
doesn't work for ftp)
3) use ado to send it there
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Aubrey" <miscuates@.online.nospam> wrote in message
news:0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com...
> How do I get a New UDF to propagate to Anonymous Merge Subscribers?
> SS2K SP4 Added New UDF <fctrptTeamReview> to Database using Wizard
> Tried CREATE in Query Analyzer, then though there might be a Stored
> Procedure . . . No joy! Checked BOL, Hilary & Paul
> --
> Aubrey Kelley
|||Thanks, Hilary!
Tried: sp_addscriptexec Database, "fullpathname\TeamReview.sql"
Subscriber Initialized OK, and got this far:
Launching osql to apply script 'TeamReview.sql'
After a few seconds it Errored Out with:
The schema script '0\\servername\ReplData\2005112082642800\TeamRevie w.sql'
could not be propagated to the subscriber.
Why is it prepending the '0' (Zero) to the Path? How can I remedy this?
Of course this had broken Merge Replication, and I cannot get rid of it!
Aubrey Kelley
"Hilary Cotter" wrote:

> your options are
> 1) create a new publication and send it
> 2) use sp_addscriptexec to deploy it to unc deployed subcribers only (it
> doesn't work for ftp)
> 3) use ado to send it there
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Aubrey" <miscuates@.online.nospam> wrote in message
> news:0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com...
>
>
|||Hello Aubrey,
It seems the configuration of the replication has some issues. Does the
issue occur if you create a new publicaiton with this shared snapshot
location? Also, you may want to try a different shared folder for snapshot
to test the situation.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Deploy New User Defined Function to Anon Merge Replicas
| thread-index: AcXt20NbtIQ7JH6qSzyDPoJAnLeSBQ==
| X-WBNR-Posting-Host: 69.218.133.236
| From: =?Utf-8?B?QXVicmV5?= <miscuates@.online.nospam>
| References: <0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com>
<unfOv7c7FHA.3048@.TK2MSFTNGP10.phx.gbl>
| Subject: Re: Deploy New User Defined Function to Anon Merge Replicas
| Date: Sun, 20 Nov 2005 06:04:03 -0800
| Lines: 49
| Message-ID: <5B5E6958-5768-4782-A676-8ED3880BC45C@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:66799
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| Thanks, Hilary!
|
| Tried: sp_addscriptexec Database, "fullpathname\TeamReview.sql"
|
| Subscriber Initialized OK, and got this far:
| Launching osql to apply script 'TeamReview.sql'
|
| After a few seconds it Errored Out with:
| The schema script
'0\\servername\ReplData\2005112082642800\TeamRevie w.sql'
| could not be propagated to the subscriber.
|
| Why is it prepending the '0' (Zero) to the Path? How can I remedy this?
|
| Of course this had broken Merge Replication, and I cannot get rid of it!
| --
| Aubrey Kelley
|
|
| "Hilary Cotter" wrote:
|
| > your options are
| >
| > 1) create a new publication and send it
| > 2) use sp_addscriptexec to deploy it to unc deployed subcribers only
(it
| > doesn't work for ftp)
| > 3) use ado to send it there
| >
| >
| > --
| > Hilary Cotter
| > Looking for a SQL Server replication book?
| > http://www.nwsu.com/0974973602.html
| >
| > Looking for a FAQ on Indexing Services/SQL FTS
| > http://www.indexserverfaq.com
| >
| > "Aubrey" <miscuates@.online.nospam> wrote in message
| > news:0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com...
| > > How do I get a New UDF to propagate to Anonymous Merge Subscribers?
| > >
| > > SS2K SP4 Added New UDF <fctrptTeamReview> to Database using Wizard
| > >
| > > Tried CREATE in Query Analyzer, then though there might be a Stored
| > > Procedure . . . No joy! Checked BOL, Hilary & Paul
| > > --
| > > Aubrey Kelley
| >
| >
| >
|
|||FYI: Further experience with Error:
The schema script
'0\\servername\ReplData\2005112082642800\TeamRevie w.sql' could not be
propagated to the subscriber.
The prepended '0' (Zero) on the Path aborted Anonymous Merge Replication
over the Internet (HTTP).
On a virgin Win XP Pro / SP2 (immediately after re-imaging from Compaq
Recovery CD's), loaded with my MS Access SQL Runtime Project. The Merge
Replication is coded in Forms based VB Modules. The Merge.Initialize worked
just fine (as always). Then 'osql' attempted to run the schema script, and
Failed!
Just for fun, I opened a VPN to the Host, tested it with Windows Explorer
(to \\hostservername) and with a VB File Copy Command Button on my
Synchronize Form. This time, the Merge worked just fine!
Conclusion: the Schema Script File needs the VPN (or LAN) to support its
File Copy.
Great learning (on Turkey Day (USA)).
Aubrey
Aubrey Kelley
"Hilary Cotter" wrote:

> your options are
> 1) create a new publication and send it
> 2) use sp_addscriptexec to deploy it to unc deployed subcribers only (it
> doesn't work for ftp)
> 3) use ado to send it there
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Aubrey" <miscuates@.online.nospam> wrote in message
> news:0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com...
>
>