I used push merge replication over internet.
I got the this error log at end of applying both schema and data to the subscriber.
General network error. Check your network documentation.
(Source: internet_ip_address\MSDE1 (Data source); Error number: 11)
The data were repliacted to subscriber.
Then, I deleted the subscription and re-created again, but selected
"the Subscriber already has the schema and data".
I got the following error:
The remote server is not defined as a subscription server
(Source: internet_ip_address\MSDE1 (Data source); Error number: 14010)
on your publisher go to Tools-Replication-Configure Publishers,
Distributors, and Subscribers, click on the Subscriber tab, and locate your
subscriber and click on the three dots (the browse button) to the right of
the subscriber and ensure that you are using the impersonate the SQL Server
account on the publisher.
Then restart your distribution agent.
"Ming Cheng" <mccheng@.msn.com> wrote in message
news:B0FA6FEE-D918-49D3-AA1F-1EDBBB36AF8F@.microsoft.com...
> I used push merge replication over internet.
> I got the this error log at end of applying both schema and data to the
subscriber.
> General network error. Check your network documentation.
> (Source: internet_ip_address\MSDE1 (Data source); Error number: 11)
> The data were repliacted to subscriber.
> Then, I deleted the subscription and re-created again, but selected
> "the Subscriber already has the schema and data".
> I got the following error:
> The remote server is not defined as a subscription server
> (Source: internet_ip_address\MSDE1 (Data source); Error number: 14010)
>
sql
Showing posts with label internet. Show all posts
Showing posts with label internet. Show all posts
Tuesday, March 27, 2012
Monday, March 12, 2012
Function to validate e-mail address
does anyone have a funciton or Stored PRoc to validate internet e-mail addresses?
I have a table of e-mail addresses, many of which are junk (the web programmer did not enforce validation on the survey form) and now i have to filter the junk out of the list.
Can any one help with this? Is there a UDF or SP floating out there I could use?These links may give you some ideas:
One that does it in the database
One that does it in C#
Subscribe to:
Posts (Atom)