Cluster and Non-Cluster Indexes

How are cluster and non-cluster indexes data moved with SQL Server 2000
Transaction Replication? I have one database that I am using to replication
to another server.
I would like to execute the dbcc reindex job on the subscriber database to
reindex all of the indexes, would this be replicated to the subscriber
database.
Thanks,
No, it isn't - it is logged though and this does affect the log reader
agent's performance.
You can replicate these commands to the subscriber using sp_addscriptexec if
all of your subscribers are deployed via unc.
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
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:8F9EC263-95CD-42D3-9C82-D5BB1DE169EC@.microsoft.com...
> How are cluster and non-cluster indexes data moved with SQL Server 2000
> Transaction Replication? I have one database that I am using to
replication
> to another server.
> I would like to execute the dbcc reindex job on the subscriber database to
> reindex all of the indexes, would this be replicated to the subscriber
> database.
> Thanks,
>
>

cloneing?

I have a merge replication that is really fouled up. I need to get things
back in order. Right now I have three offices working on the database
locally(no replication going on) At the end of the day I want to get all of
the new data back to the publisher so we can create a new snapshot. I was
told by the software vendor of the interface of the database to clone
without hostnames or supporting records. I am kinda at a loss as to what
that means. I see that I can export the data to another server and choose to
append the data, is that what he meant? Any help would be very much
appreciated.
Curt
I suggest you contact the vendor and ask him exactly what he means. Say you
did a search on BOL one clone, cloning and supporting records and came up
with no results.
If you do a reinitialization you will be prompted to upload the changes from
the subscribers before reinitializing. Perhaps this is what the vendor
meant.
I suggest before you even do this you go through the conflicts table(s)
using the conflict viewer and resolve any conflicts.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Curt Shaffer" <curt@.chilitech.net> wrote in message
news:ch4k8c01hif@.enews3.newsguy.com...
> I have a merge replication that is really fouled up. I need to get things
> back in order. Right now I have three offices working on the database
> locally(no replication going on) At the end of the day I want to get all
of
> the new data back to the publisher so we can create a new snapshot. I was
> told by the software vendor of the interface of the database to clone
> without hostnames or supporting records. I am kinda at a loss as to what
> that means. I see that I can export the data to another server and choose
to
> append the data, is that what he meant? Any help would be very much
> appreciated.
> Curt
>

Client/Server Connection

Hi ;

I m trying to create Merge Replication. I was able to create the
replication on the same machine, however my aim is to use client
machine and do all the neessary work on the client machine and then
synchronize to the server. Thus, I have installed client version of SQL
2000, I connected to the database server, the thing is when I go off
line I lose connection. Is there any way to create the subscription in
to the client machine as an off line user then synchronize it ?Or DO I
have create my shopshot on the client machine?
If someone can help me I would really appreciate

Regards
AsI think the problem is with how you are connecting to the server.
Instead of using the network name when you register the server, use
<local> or '.' Your subscription must be created on the server.

client side triggers?

in merge replication using sql server 2005 and sql server compact, is it possible to have triggers (or business logic) for any changes on the client side? how does a client app know an insert/update/delete has been made? also, if the article is set to download-only, can the client app also be nofied of any changes?

thanks,

bryan

Yes you can set your triggers to be FOR REPLICATION

That way they will fire when an insert,update or delete comes through replication.

Applications usually do not get notified of changes in the database by the database system. This would be possible using the CLR however normally it is the application that queries the database to see if changes have occured.

Martin

Client Certificates with SQL Mobile replication

I am currently trying to replicate a SQL Mobile 2005 database with a SQL Server 2005 database through web synchronization using SSL Server AND Client Certificates. On IIS, with "Require Client Certificates" unchecked, I can replicate fine. Once I turn it on, I get a message from replication saying "A Secure Socket Layer connection is required to access this site". I have installed a client certificate in IE, and can access the https://servername/Ojt/sqlcesa30.dll site (I tried removing the client certificate, and I was denied access, then reinstalled it and it worked - so I think that part is working). Does anyone have any experience with this? My production operating environment requires client-side certificates.

Can you make sure you have https:// in your client application and not http://?|||Yes, https works. Like I said, if I'm using only Server certificates, there's no problem - I've turned off non-ssl ports. Also, if I'm looking at the url in the browser with Client certificates turned on, it prompts me for a certificate, and then loads the page fine. But then if I go over to SQL Server management studio and try to synchronize my .sdf, I get the SSL error.|||

FYI, I just found this page on MSDN:

http://msdn2.microsoft.com/en-us/library/ms152511.aspx

which says "Web synchronization for merge replication supports using server certificates but not client certificates."

Can anyone verify this? Has anyone ever successfully used a client certificate with merge replication?

|||A server certificate is indeed required for web synchronization, with client certificate it will fail.

Client Agent Error: integrity violation

Hello:

I tried to do the merge replication between SQL 2000 database and the SQL mobile server on PDA with SQL server management studio from SQL 2005 and I have already successfully synchronized my PDA with one small SQL server database file. However when I tried to synchronized my PDA with another larger SQL server database file, I got the error on PDA as following: “The row operation cannot be reapplied due to an integrity violation. Check the publication filter. [Table = AuditCriterion, operation = Insert, RowGuid = {1ee9321d-f00d-410c-8d5b-08d4220d2627}]”. I have keep checking the size of sdf file during synchronization, I found after the size of the sdf file stop increasing for about 20 mintues, then I got the error above. Morever, AuditCriterion table have a foreign key with another table AuditElement and I have not used publication filter at this stage.

Please help thanks.

Eddie

If AuditCriterion has as a foreign key with AuditElement have you included both tables in the publication?

If the table is missing the insert will fail because SQL Server 2000 cannot find the required primary key.

Thanks

Nabila Lacey

clearing up replication

Hi
I am trying to clear up replication on our server and under Replication
Monitor\Publishers..there is a publication I want to get rid of as the db no
longer exists. When I try to delete it I get the error msg:-
Error 21766...The name 'abc' was not found in the TransPublications
collection...
I've been trying to find info on how to get rid of this and can't seem to
find anything of use so does anyone have any ideas?
Thanks
Jonjo
I'm not sure if this helps for you but did you try:
sp_removedbreplication 'dbname'
"jonjo" wrote:

> Hi
> I am trying to clear up replication on our server and under Replication
> Monitor\Publishers..there is a publication I want to get rid of as the db no
> longer exists. When I try to delete it I get the error msg:-
> Error 21766...The name 'abc' was not found in the TransPublications
> collection...
> I've been trying to find info on how to get rid of this and can't seem to
> find anything of use so does anyone have any ideas?
> Thanks
> Jonjo
>
>
|||Hi Umut
Yea, I tried that but it tells me the db does not exist..which I knew anyway.
"Umut Nazlica" wrote:
[vbcol=seagreen]
> I'm not sure if this helps for you but did you try:
> sp_removedbreplication 'dbname'
>
> "jonjo" wrote:

clearing up replication

Hi
I am trying to clear up replication on our server and under Replication
Monitor\Publishers..there is a publication I want to get rid of as the db n
o
longer exists. When I try to delete it I get the error msg:-
Error 21766...The name 'abc' was not found in the TransPublications
collection...
I've been trying to find info on how to get rid of this and can't seem to
find anything of use so does anyone have any ideas?
Thanks
JonjoI'm not sure if this helps for you but did you try:
sp_removedbreplication 'dbname'
"jonjo" wrote:

> Hi
> I am trying to clear up replication on our server and under Replication
> Monitor\Publishers..there is a publication I want to get rid of as the db
no
> longer exists. When I try to delete it I get the error msg:-
> Error 21766...The name 'abc' was not found in the TransPublications
> collection...
> I've been trying to find info on how to get rid of this and can't seem to
> find anything of use so does anyone have any ideas?
> Thanks
> Jonjo
>
>|||Hi Umut
Yea, I tried that but it tells me the db does not exist..which I knew anyway
.
"Umut Nazlica" wrote:
[vbcol=seagreen]
> I'm not sure if this helps for you but did you try:
> sp_removedbreplication 'dbname'
>
> "jonjo" wrote:
>

clearing up replication

Hi
I am trying to clear up replication on our server and under Replication
Monitor\Publishers..there is a publication I want to get rid of as the db no
longer exists. When I try to delete it I get the error msg:-
Error 21766...The name 'abc' was not found in the TransPublications
collection...
I've been trying to find info on how to get rid of this and can't seem to
find anything of use so does anyone have any ideas?
Thanks
JonjoI'm not sure if this helps for you but did you try:
sp_removedbreplication 'dbname'
"jonjo" wrote:
> Hi
> I am trying to clear up replication on our server and under Replication
> Monitor\Publishers..there is a publication I want to get rid of as the db no
> longer exists. When I try to delete it I get the error msg:-
> Error 21766...The name 'abc' was not found in the TransPublications
> collection...
> I've been trying to find info on how to get rid of this and can't seem to
> find anything of use so does anyone have any ideas?
> Thanks
> Jonjo
>
>|||Hi Umut
Yea, I tried that but it tells me the db does not exist..which I knew anyway.
"Umut Nazlica" wrote:
> I'm not sure if this helps for you but did you try:
> sp_removedbreplication 'dbname'
>
> "jonjo" wrote:
> > Hi
> >
> > I am trying to clear up replication on our server and under Replication
> > Monitor\Publishers..there is a publication I want to get rid of as the db no
> > longer exists. When I try to delete it I get the error msg:-
> >
> > Error 21766...The name 'abc' was not found in the TransPublications
> > collection...
> >
> > I've been trying to find info on how to get rid of this and can't seem to
> > find anything of use so does anyone have any ideas?
> >
> > Thanks
> >
> > Jonjo
> >
> >
> >