SQL Server 2000 I'm gettting this error when I try and apply the snapshot: "The query processor could not produce a query plan from the...

Scagnetti

03-30-2010 09:44 AM
Scagnetti

We have engaged a partner to implement a design for data transactinoal flow, bi-dreictionally, between our web store at one physical location and...

zaw

03-29-2010 02:51 PM
zaw

One of my subscriptions recently stopped replicating. When I went to view the subcription agent it pops up with this message: "The specified...

Tony

03-29-2010 11:22 AM
Damer Serrania

I have an application that is storing a lot of data in a SQL 2005 database (adding around 50 million rows) in a window of about 6 hours each day. ...

SherryH

03-25-2010 03:46 PM
SherryH

Hi, I try to use the peer-to-peer replication, I follow the step in "Configure Peer-to-Peer Transactional...

Benoit Dufort

03-25-2010 07:35 AM
Benoit Dufort

we have two databses in merge replication. there are tables with identity and we use automatic identity range management. from one of these servers,...

DavidIBA

03-25-2010 05:50 AM
DavidIBA

Hi, I work for a small business. We have SQL Server 2005 Standard running on our office server. We also have a remote web server (hosted by...

Ben S

03-24-2010 08:26 PM
Jay Konigsberg

Thanks a lot it works. "Paul Ibison" wrote:

wadii boulila

03-23-2010 11:40 AM
I would like a replication that not ex

Hi Paul, Thanks for the response. It should all work in principal and i did not change the job names. This is all a bit flakey for me and you could...

Siz

03-22-2010 12:25 PM
Siz

I did a little digging for you and found a relevent page. Using Multiple Versions of SQL Server in a Replication...

Jay Konigsberg

03-21-2010 11:27 AM
Jay Konigsberg

I have the following senario: SqlServer A in outside the corp firewall in the DMZ. SqlServer B is inside the corp firewall. I want to sync data...

Eddie

03-21-2010 05:13 AM
Paul Ibison

Hi is there any built in notification setting (SQL Server 2005) when an error occurs during replication. by error I mean for example if a sync...

pezi179

03-19-2010 08:08 AM
Ben Thul

Hi NG! We just upgraded a SQL Server 2000 to 2005 and have a problem with replication. The SQL Server 2005 should replicate its data to a SQL...

Stefan

03-18-2010 07:59 PM
Ben Thul

I have a problem with replicating table that have 1 geometry column. Environment: 1. Publisher - MS SQL Server 2008 Standard 2. Subscriber - MS SQL...

Sergii Kryshtop

03-18-2010 10:22 AM
fw190 tlt

Hi guys, I have a problem when synchronizing web publication. I begin by giving you an insight into my soft installed: -sql-server 2005 -windows...

Tunisien86

03-17-2010 04:36 AM
Tunisien86

I am reposting this from the Sql Server Forum. We are using Sql Server 2005 9.00.4035. We have a hub and spoke topology which includes 6 tables with...

CindyB

03-16-2010 01:49 PM
CindyB

Hello all I am using sql server 2000 sp4 (boy do I feel obsolete) I am trying to prepare for replication (transactional Replication ). The manual I...

Andre Gibson

03-15-2010 02:19 PM
Andre Gibson

SQL Server 2008 Standard SP1 Publisher and Server 2005 and 2008 Express subscribers. I have merge replication setup and working great, except for a...

dday515

03-13-2010 03:31 PM
dday515

Can some tell me what this mean: ( view log reader agent status ) Cannot execute as the database principal because the principal "dbo" does not...

CEN05

03-12-2010 12:59 PM
CEN05

We are in need of help with a problem dealing with RMO conflict resolvers in merge replication. This is our first shot at it so we may have...

PaulW

03-10-2010 10:04 AM
PaulW

Hi, I am reposting this from the main SQL Server forum. We are in the process of migrating from one DC to another. I setup a transactional...

Malik

03-08-2010 02:01 PM
Ben Thul

Thanks a lot finally it works!!! Please how can I get the name of the replication agent. For example, when I drop the replication and I recreate it,...

wadii boulila

03-08-2010 01:34 PM
Ben Thul

I am a bit confused. Does a client running SQL Server Compact 3.5 subscribing to a SLQ2008 publisher require that IIS run ON THE CLIENT?? Thanks

GADOI

03-08-2010 10:58 AM
ErikEJ

Using SQL 2005 SP2. I have a publication that contains indexed views, and some other objects that query the indexed view using WITH (NOEXPAND)....

jk

03-04-2010 10:52 AM
Ben Thul

Win 2003 Server / SQL 2005 SP2 Std Ed Pub/Subscribers(7-LAN, 1-WAN) / Distr (dedicated) I have a pub w/ 200 tables, approx 30gb Subscriber is...

Chris

03-03-2010 02:35 PM
Chris

I have performed a transactional replication in my company. This done through a script SQL that I wrote. Everything is OK. However,...

wadii boulila

03-03-2010 02:12 PM
Paul Ibison

hi all, I've a transactional replication, now this replica hangs because of a command that has generated an error. With sp_browsereplcmds I have...

Andrea Caldarone

03-03-2010 02:25 AM
Andrea Caldarone

I have setup a transactional replication and I want to be able to skip errors 2627 and 20598 due to project requirement.... The replication...

CEN05

03-02-2010 05:12 PM
Ben Thul

Hello, I've setup transactional replication between two SQL servers. The publication database is on a standalone server and the subscription runs...

Jens

03-02-2010 02:09 AM
Jens

Hello! I am having typical scenario in sql merge replication. I need to synchronize table with data and schema changes. But for one column in the...

Manish

03-02-2010 01:34 AM
Manish

Last Friday, a request came to add two new articles to our transactional replication setup. I did things as I normally do (i.e. sp_addarticle &...

Ben Thul

03-01-2010 10:07 AM
Ben Thul

Hi Paul, Yes, i will do that next time when i encounter the issue as I have reinitialized the repl. and users did not reporduce the issue yet. Btw,...

Manoj Kumar

03-01-2010 12:34 AM
Manoj Kumar

I just realized that when I sever the connection between the publisher and describer, writes fail b/c it complains about not seeing the other...

michael

02-26-2010 11:00 AM
michael

Hello, We are mirroring a SQL Server 2008 Entreprise database over to another SQLServer on another server. We had issues setting this up due to...

Kerry

02-24-2010 04:30 PM
B.Edwards

Hello! I have upgraded several databases from 2005 to 2008. I configured replication (created publisher and subscriber) and log reader for a...

Igor Marchenko

02-24-2010 10:18 AM
Igor Marchenko

All servers are running SQL 2005. I created a UDF that returns one value ~~~~~ create FUNCTION dbo.WhatLocationIsThis() RETURNS numeric...

LPR-3rd

02-24-2010 09:50 AM
LPR-3rd

I have performed a transactional replication in my company. However, replication agents are idle. I need a script or a command sql to start the three...

wadii boulila

02-22-2010 01:45 PM
wadii boulila

許多性能å•�題和安全性您的計算機é€*æˆ�惡æ„�病毒，最好的辦法å°�付，這是得到承èª�和防病毒在計算機上安è£�æ›´æ–° æ...

antivirus gratis

02-22-2010 01:28 PM
antivirus gratis

My distribution server failed. Because of that my publishing database log file will not shrink because it is waiting to push out the transactions....

Rick

02-21-2010 01:17 PM
Rick

Paul, I have run the profiler, but I do not see anything other than the SPs that are called. There is not additional information. Should I run a...

LPR-3rd

02-17-2010 10:30 AM
LPR-3rd

I have 2 servers (server A and Server B), both with one database that contains two tables (we'll call them MainTable and StageTable). These...

Ken

02-16-2010 10:59 PM
Ken

SQLException: Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation...

michael

02-16-2010 11:43 AM
michael

Greetings all I have P2P set up, SQL 2008 Ent, 2 peers, been working well for a month or 2. After a recent large 'update' statement affecting 25k...

Ronnie R

02-14-2010 05:34 AM
Ronnie R

All servers running SQL 2005 SQL server (NOLA) replicates to 35 remote locations (StoreXX). Earlier this week, one publication started having...

LPR-3rd

02-10-2010 11:46 AM
LPR-3rd

Hi, I have a problem with the mirroring database not starting as Principal when the principal server is unavailable. We have configured the...

Kenneth

02-09-2010 03:58 AM
Kenneth

--Topology-- I've got a one way transactional push replication going over a 1mb WAN to a datacenter in another state. The Distributor is running on...

Will Spurgeon

02-08-2010 03:49 PM
Will Spurgeon

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

02-08-2010 10:23 AM
Mia

We're in the process of relocation some SQL servers & upgrading from 2k5 to 2k8. I've created a number of transaction replications that are working...

BigSam

02-08-2010 09:02 AM
BigSam

Hi paul Yes it was a typo. This issue turned out to be a "production restore" issue. The Prod backup was loaded into QA, then schema changes...

dbaeiss

02-08-2010 04:26 AM
dbaeiss

Hi. I have two servers in different locations running SQL Server 2005 merge replication. I need to upgrade the suscriber server to SQL Server 2008....

José Luis

02-05-2010 10:01 AM
José Luis