Hello Priyanka,

Sorry, you are right it is an Extended Stored Procedure. It may then be because it is nondeterministic.

Have you considered using the Query() method on an XML variable instead...

Hello Priyanka,

You usually get that error because UDFs cannot perform actions that modify the database state or execute SPs.

I guess then that it is the sp_xml_preparedocument that is the root...

Hello,

Can you successfully Ping the IP Address from your PC?

Regards,

John Marsh

Hello,

Sorry, but I can't see your question. Can you re-post?

Regards,

John Marsh

Good Morning,

For me the usual suspects are (in order of likelihood):-

1) Share or File-System Permissions

2) Authentication failure

3) Network issues

4) Something Weird

The tests so far seem to be ruling out the...

Hello,

You should be able to type the Share name into the Registry key in plain text

Although spaces in the path shouldn’t be a problem, I have seen posts claiming that...

Hello,

Yes, that implies it is not a Folder permissions issue. Just to double check though, that you did restart the "Server" Service on the Target Server, after making the Registry...

Hello,

I guess you could temporarily try the registry update and then back it out. At least that way you would be sure to eliminate permissions as the cause (or not).

Regards,

John...

Hello again,

If your share and File-System Permissions do seem fine, and you are really stuck, then the following article suggests an "if all else fails" option. As it removes security...

Hello,

Does the SQL Service Server Account have write access to the target folder at both the Share and File-System level?

Do you get the errors detailed in the MS KB article:...

Hello,

If like us, you have multiple environments i.e. Dev, UAT, Production, you might find it easier to handle packages as files.

This way you can be sure to promote the...

Hello,

That is (unfortunately) not an error message. Is there any more text after it?

If you run the SP manually can you see any blocking processes (via sp_who2)? Otherwise you could...

Hello Paul,

You can view the Conflict Resolvers on the Article's Properties pages (there's a separate Tab for Resolvers), but I guess now that it will just show Default in your...

Hello Paul,

Got to admit that I'm more familiar with Transactional and Snapshot replication, but below is my best guess, for what it's worth:-

As you're using Merge Replication I wonder if...

Hello,

When you say "after several days it all goes missing", do you mean that new data is not being replicated to the subscriber, or that previously replicated data is no...