Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts

Sunday, March 11, 2012

29006 SQL SERVER ERROR

HI, I'm getting this error on a merge subscription between SQL SERVER
2000 and SQL SERVER CE 2.0. Ocurrs 4 error:
1. A call to SQL Server reconciler failed. 29006
2. The process could not log conflict information.
3. {call [ap_cft_956C31C4D7234B324E83FF479D5444B7](?,?,?,?,?,?,?)}
4. Datetime field overflow
Any Idea?
Thanks,
Yllen
Is this a custom resolver? If not can you enable logging and post the
complete log here?
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
"Yllen" <yguevara@.gmail.com> wrote in message
news:1126629526.156630.85200@.g47g2000cwa.googlegro ups.com...
> HI, I'm getting this error on a merge subscription between SQL SERVER
> 2000 and SQL SERVER CE 2.0. Ocurrs 4 error:
> 1. A call to SQL Server reconciler failed. 29006
> 2. The process could not log conflict information.
> 3. {call [ap_cft_956C31C4D7234B324E83FF479D5444B7](?,?,?,?,?,?,?)}
> 4. Datetime field overflow
> Any Idea?
> Thanks,
>
> Yllen
>

Sunday, February 19, 2012

2005 product key

I just downloaded sql server 2005 dev edition from my msdn subscription,
however, in the listing of product keys, I dont see any keys for sql server.
Dont I need a product key for this when I install it?
moondaddy@.nospam.nospamNot for Dev edition, no.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"moondaddy" <moondaddy@.nospam.nospam> wrote in message
news:OWi1L2X5FHA.1864@.TK2MSFTNGP12.phx.gbl...
>I just downloaded sql server 2005 dev edition from my msdn subscription,
>however, in the listing of product keys, I dont see any keys for sql
>server. Dont I need a product key for this when I install it?
> --
> moondaddy@.nospam.nospam
>|||Download the DVD edition (sorry). There was a problem with the initial CD
style distribution that incorrectly required product keys; I hope the
problem isn't that you started the download a w ago and only just
finished. The MSDN version of SQL Server 2005 should not require product
keys at all.
"moondaddy" <moondaddy@.nospam.nospam> wrote in message
news:OWi1L2X5FHA.1864@.TK2MSFTNGP12.phx.gbl...
>I just downloaded sql server 2005 dev edition from my msdn subscription,
>however, in the listing of product keys, I dont see any keys for sql
>server. Dont I need a product key for this when I install it?
> --
> moondaddy@.nospam.nospam
>|||moondaddy wrote:
> I just downloaded sql server 2005 dev edition from my msdn
> subscription, however, in the listing of product keys, I dont see any
> keys for sql server. Dont I need a product key for this when I
> install it?
It might have the key built into the download. Some products work that
way to ease installation. Start the install and see.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Monday, February 13, 2012

2005 Express: testing replication

Hello,
I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got error: "There are no
publications to which you can subscribe, either because this server
has no publications or because you do not have sufficient privileges
to access the publications."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:

Quote:

Originally Posted by

Hello,
I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got error: "There are no
publications to which you can subscribe, either because this server
has no publications or because you do not have sufficient privileges
to access the publications."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/


SQLExpress can use Replication, but only as subscriber. And your message
says, SQLExpress cannot access the publisher. Do you have a publisher
running? Publisher cannot be done with SQLExpress.

bye, Helmut|||On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@.inode.at>
wrote:

Quote:

Originally Posted by

>Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:
>

Quote:

Originally Posted by

>Hello,
>I am learning SQL Server 2005 Express. I need to test replication but
>when I run New Subscription Wizard I got error: "There are no
>publications to which you can subscribe, either because this server
>has no publications or because you do not have sufficient privileges
>to access the publications."
>I see no option for publications. Does this mean that in Express I
>cannot run replication? If I can, how?
>Thank you very much
>/RAM/


>
>SQLExpress can use Replication, but only as subscriber. And your message
>says, SQLExpress cannot access the publisher. Do you have a publisher
>running? Publisher cannot be done with SQLExpress.
>
>bye, Helmut


thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?

/RAM/|||Am Fri, 07 Jul 2006 16:05:09 +0200 schrieb R.A.M.:

...

Quote:

Originally Posted by

BTW, is Replication and Data Mirroring the same thing?
>
/RAM/


Hmm, i am no expert for this. As much as i know is, that data mirroring
means it happens in real time, so you can switch with no delay from one
server to the other one. Replikation goes in intervals, between the
intervals data between the two databases is different. But i am not sure if
this is the right definition.

bye, Helmut|||"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:v7qsa2tmij36hi65heqv02j8p52t59nesi@.4ax.com...

Quote:

Originally Posted by

On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@.inode.at>
wrote:
>
thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?


No.

Quote:

Originally Posted by

>
/RAM/
>