| Groups | Blog | Home |
|
April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 2 machines..how hard could it be Posted by JEFFREY BRANDT at 8/31/2006 11:39:27 PM I have two Windows XP SP2 machines with full installs of SQL Server 2005.
Both machines are on a Class III private network with four computers on it,
and no server.
Machine A has a database that we'd like to end up, in full, on Machine B,
once per day at 12:05AM.
Seems like Machine A should...more >>
Performance Issue When Changing Identity from Yes to Yes Not for R Posted by Larry Herbinaux at 8/31/2006 4:33:01 PM We created a script to create new tables for all tables that have an Identity
column. The new tables now have Identity (Not For Replication). We then
copied all the data to the new tables, dropped the old tables and renamed the
new temporary tables back to the original table name.
We then...more >>
Error: Syntax error or access violation Posted by emgeneral at 8/31/2006 2:41:01 PM In my replication, I noticed the following error. Can you guide me to the
right direction to troubleshoot this.
In the Last command section:
{CALL sp_MSins_GCFD$Sales Header (0x0000000001b52c48, 1, 'ORD211801', '',
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 2006-08-31
...more >>
Queue Reader Agent won't restart Posted by Tom T at 8/31/2006 11:16:01 AM I have installed transactional replication with queued updating on a sql
server 2000 (SP4) system. It has run fine until the other when the network
went down. When it came back up, replication came back up successfully except
for the queue reader agent. I researched the problem and it was due ...more >>
Add Merge Subscr w/ 'nosync' doing may metadata updates??? Posted by Chris at 8/31/2006 8:08:01 AM
Publisher: SQL2000 Ent Ed sp4
Distributor: SQL2000 Ent Ed active/passive cluster sp4
Subscriber: SQL2000 Std Ed sp4
I dropped an existing subscription in a 30 table merge pub (5 tables w/
1Mill+ rows), performed table maintenance at subscriber, then added
subscription w/ @sync_type = 'non...more >>
Merge Replication-Pull Subscription-Error? Posted by Vikas at 8/31/2006 2:01:01 AM Hi all,
I have a issue with merge replication. I have setup replication
between 2005 and 2000 SQL Server. But, i cannot initiate replication bcaz
"JOB HISTORY" says the following:
step ID 1
Server Store_Server
Job Name Centre_Server_CentreDB_CentrePublicat...more >>
Server is not a subscriber Posted by Paul Linton at 8/30/2006 7:36:01 PM Hi,
I have a SQL2005SP1 publushed database with 4 merge subscribers, everything
has been running just fine for month now. Yesterday two of the subscribers
stopped merging. This happened when I installed Reporting Services on the
publisher.
From Management Studio, if I right click on one ...more >>
Violation of UNIQUE KEY constraint 'unique_pubsrvdb' Posted by Bryan Bain at 8/30/2006 9:04:41 AM I have 13 push subscriptions all using SQL Server 2000. The
publisher/distributor are together on another server are also on SQL Server
2000.
Subscriptions have been running for years without problems. Yesterday, 2 of
the subscriptions started erroring. The error message is the same on both...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Alter View in Replicated Database Posted by EoRaptor013 at 8/30/2006 8:54:31 AM Does anybody know of an example script to quiesce a peer-to-peer
replication, alter a view, make sure the alterations are propagated and
re-activate the replication?
I gather I have to execute sp_requestpeerresponse and
sp_helppeerresponse, then alter the table. Trying to build up to the
corr...more >>
Single point of failure Posted by Lauren at 8/30/2006 7:46:01 AM Hi,
After some very helpful advice from this forum, I have set up Merge
replication on 2 SQL Server and 1 SQL Express machines. One of the SQL
Servers has been configured as the publisher and the other one and the SQL
Express as subscribers.
This grouping of machines will be repeated th...more >>
Bi-directional transactional replication Posted by almurph NO[at]SPAM altavista.com at 8/30/2006 3:08:25 AM Hi everyone,
Hope that you an help me with this one - I'm new to the whole
replciation business. I'm going to implement bi-directional
transactional replication on 2 servers that I have - I'll call them "A"
and "B" for the sake of simplicity.
The protocol that I am following is the one at t...more >>
Merge Groundhog Day Posted by peetyport NO[at]SPAM gmail.com at 8/29/2006 11:56:34 AM
I have merge replication running with the following topology:
SQL2K5(PUB)------->SQL2K5(REPUB/SUB)------->SQLExpress2K5(SUB)
So, I have a publication which is pulled by two
republishers/subscribers. My clients pull from one of the two
republishers. The articles are filtered by HOSTNAME()...more >>
am i going crazy or sp_publication_validation is? Posted by Koni at 8/29/2006 11:00:27 AM sp_publication_validation does not seem to show any errors/mismatches
after I delete a bunch of rows from a subscribed table. The ManStud GUI
validation function works fine and catches the mismatch in row counts.
use opeidev
go
declare @ReturnCode int
exec @ReturnCode = sp_publication_va...more >>
replication SPs exhibiting inexplicable behavior Posted by MorDeRor at 8/29/2006 8:52:01 AM Hello everyone,
We have SQL 2000 servers connected by transactional replication. We are
using custom SPs to push data accross. Suddenly this morning, replication
started acting strange, to be more descriptive -
one of the articles has 8 columns and is defined to use MCALL type SP for
upda...more >>
Snapshot replication - how is the publication applied? drop/create? Posted by stantale at 8/29/2006 5:52:39 AM Hi,
My main question is whether the operation is atomic or not. For
snapshot replication in sql server, how does the subscription server
apply the table change - is it a drop/create, or a truncate/bcp? And is
it wrapped in a transaction.
Replication is happening roughly every minute (for a ...more >>
Any licensing issues Posted by Rob at 8/29/2006 4:48:01 AM Is there any licensing requirement for either push/pull merge replication
from SQL 2005 Standard Edition (Publisher) to SQL 2005 Express (Subscriber),
we have a per processor license.
Thanks in advance
Robbie...more >>
sp_scriptpublicationcustomprocs truncation of scripts Posted by Peter Doyle at 8/29/2006 4:46:02 AM Is there any way of preventing this stored procedure from truncating the
final scripts it produces (for sp_MSins_*, sp_MSUpd_* and sp_MSDel_*) if a
large number of columns are used in the replication model?
Thanks
--
Peter Doyle...more >>
Merge replication become very slow Posted by Atle Kaaven at 8/29/2006 12:00:00 AM Kan anyone help me with this one?
I have Merge replication set on a SQL server 2005 for about 20 salesmen
using SQL Mobile. It used to be OK before, but now it has become very slow.
I can see in the monitor that there are about 170000 inserts and 110000
deletions when I test on an initial syn...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |