|
|
|
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 replication error with trigger Posted by stephanie at 6/14/2006 8:15:01 PM I found a problem in replication which we have 3 tables, namely tab A, tab B
and tab C
replication will apply on tab A and tab B
and there is a trigger on tab A and tab B, whenever insert/update on tab A
it fires trigger to update tab b
whenever insert/update on tab B it fires trigger t...more >>
Merge Replication Updates on initialize (SQLServer 2005) Posted by SteveM at 6/14/2006 5:51:02 PM I have a merge replication scenario where the technicians are filtered by
their individual codes. Each technician has his own mobile device for
collecting and synchronising data.
On initialisation of the subscription, the user should only get the data
that is relevant to their code.
The ...more >>
Contents of conflict tables not restored with keep_replication Posted by Governor at 6/14/2006 1:41:02 PM We are trying to recover lost rows from a database backup. The rows were lost
in replication and should be in the conflict tables in the database, but when
we restore the database backup with the keep_replication option, although it
creates the conflict tables it doesn't seem to restore any da...more >>
SQL2005 - 2000 Transactional - Snapshot failure Posted by Jeff Ericson at 6/14/2006 1:37:02 PM I am moving some transactional replication from a 2000 to a 2005 box but
replicating back to a 2000 box. I have recreated the pull subscriptions on
the 2000 side but they fail if the snapshot folder is left as the default.
It seems as though the agent on the 2000 box is simply looking into t...more >>
SQL Mirroring supported in production by MS? Posted by Will D. Robinson [MVP] at 6/14/2006 9:49:36 AM A technet article from April 2005 states SQL Server 2005 database mirroring
is not supported by Microsoft in production. Is this statement still valid?
We are looking at rolling out SharePoint 2007. Mirroring is an interesting
backup solution. Here is the article.
http://www.microsoft.co...more >>
Merge replication Error (-2147467259) Posted by Wellington Sampaio at 6/14/2006 6:37:01 AM Hello!
I got the following error in my merge replication.
Category:NULL
Source: Merge Process
Number: -2147467259
Message: The Stored Procedure Resolver encountered the following error
executing the stored procedure '[dbo].[stp_Repl_dml_estoque]'. Server
'SERVIDOR' is not configured f...more >>
Server Renamed - Replication doesn't work Posted by Jeff Ericson at 6/14/2006 5:33:02 AM A 2005 server was renamed while replication was configured. I was able to
drop the publication, distributiondb, etc. using the sprocs but I can't
reconfigure due to SQL asking me to refer directly to the server name, not an
alias, IP, etc.. The server name it thinks I should use is the old s...more >>
Data Synchronization Posted by Amit Bansal (MCT, MCSD.NET) at 6/14/2006 12:00:00 AM Hi,
I have 2 identical databases. I make changes to one and that should get
updated to the other DB. I have identity columns as primary key on the
master tables and also the child tables. What approach I can used to
syncronize? I was thinking of removing identity and using GUID instead. It
wi...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to pause transactional replication during import at publisher? Posted by Patrick Gibb at 6/13/2006 7:10:59 PM Hi
I have a Publisher that will be replicating configuration data and user data
(UserNames, Locations and Departments etc) down to a set of Subscribers. I
have been asked to use transactional replication so that any changes are
replicated to the Subscribers immediately, but at the same tim...more >>
Resize column during replication Posted by Philippe at 6/13/2006 2:05:02 PM Hello,
How do I do to resize a column in a replicatied table on the publisher,
without dropping curent replication ?
Thank's...more >>
Merge Replication become too slow Posted by ponnu at 6/13/2006 8:31:03 AM There are 671 merge articles on the publisher,
When subscriber starts to synchronising data
Why Processing Article takes long time before transferring data ?.
Any help would be appriciated.
Best Regards
Ponnu MCDBA
...more >>
SQL server and SQL agent services' logon account for Replication Posted by Lavanya at 6/13/2006 2:20:34 AM Hi,
When is it necessary for these 2 services to have 'this account' logon
credentials?
I have a simple Transactional setup with local distributor and pull
subscription. Some articles say that these services should not be run
in local system account for replication. However, its working for...more >>
SQL 2005 - Full Text Index and Merge Replication Posted by Venketash (Pat) Ramadass at 6/13/2006 12:00:00 AM Hi there,
We are using merge replication over HTTPS between a SQL 2005 Standard
publisher db and SQL Express 2005 with Advanced Services subscribers. The
SQL Express instances have been installed with the following command line...
SQLEXPR_ADV.EXE /qb INSTANCENAME=<instancename>
ADDLOCAL=...more >>
drop column and aDD column Posted by Christophe at 6/13/2006 12:00:00 AM On transacional Replication
if possible to (this commands not trouble the replication ????)
ALTER TABLE myBase.dbo.myTable DROP CONSTRAINT
--Drop Key
ALTER TABLE myBase.dbo.myTable DROP COLUMN
--Drop column
ALTER TABLE myBase.dbo.myTable ADD uid int NOT NULL
...more >>
Transactional with queued updating replication-problem Posted by jane doe at 6/12/2006 11:20:44 PM Hello,
I studied Transactional with queued updating replication. But I've the
problem now.
The Problem is Replication fails with Error 208 "
Error 208: Invalid object name 'object_name'.
Unable to replicate a view or function because the referenced objects
or columns are not present on the S...more >>
MSmerge_history delivery_time seems wrong in 2000 Posted by JIM at 6/12/2006 5:19:14 PM Hi all,
I am trying to use delivery_time to gauge the performance of my merge
agent.
In BOL this is defined as Number of seconds it took to apply a batch of
changes. In SQL Server 2000 this figure appears wrong.
I run the following select statement.
select start_time,time,delivery_tim...more >>
sp_MSsub_check_identity performance Posted by Jason Jahn at 6/12/2006 2:48:01 PM Hello,
I have a transactional w/ updating publication with about 150 tables. A
bunch of these have identity fields. Using the SQL Server profiler on the
subscriber, I can see that very often (varying from 1-5 seconds), there is an
"exec sp_MSsub_check_identity @lower_bound_id = 0" being run...more >>
Foreign Key Bound To Unique Field Fails to Replicate Posted by Howard Swope at 6/12/2006 2:37:27 PM SQL Server 2000, Transactional Replication with One Time Snapshot,
Subscriber Pull
When the snaphot is applying foreign key constraints on the subscriber there
is a failure whenever a foreign key is bound to a field with a unique
constraint as opposed to a primary key. An in fact when I loo...more >>
Sql 2000 replication 18483 Posted by miguel.salles NO[at]SPAM gmail.com at 6/12/2006 12:07:50 PM Hi,
I want to replicate one of my databases among two servers.
For starters I'm tryng to create a distributor/publisher server on
server 1.
I tryed to do it using the enterprise manager and got the "Error 18483:
Could not connect to server "Server1" because "distributor_admin" is
not def...more >>
Log Reader Posted by Michael Swinarski at 6/12/2006 11:13:02 AM Is there a way to check how far behind the log reader is for a specified
table or subscription?...more >>
Undistributed Commands Posted by Michael Swinarski at 6/12/2006 11:11:01 AM In the Replication Monitor, you can click on a specific subscription. In
there, you can click on the "Undistributed Commands" tab and see who many
items are in the distribution database that are yet to be replicated for a
particular subscription.
Is this done by a stored procedure in the b...more >>
SQLDMO.DistributionDatabase2 Posted by FabioB at 6/12/2006 9:49:01 AM Hi all,
I've some difficult using StandardPassword property of
SQLDMO.DistributionDatabase2 using SQLDMO object.
When we leave StandardPassword property empty, a new Distribution Database
work fine.
When we need to setup pasword, the subsequent access to the Publisher fail
with error 18456 ...more >>
Microsoft SQL Merge control (sqlmergx.dll) Posted by FabioB at 6/12/2006 6:14:02 AM Hello all,
I've developed a small application (using VB6) in order to assist users
during creation operation of data base publication and subscription for data
replication process.
To do this we have used :
- SQLDMO Object Library
- Microsoft SQL Snapshot control
- Microsoft SQL Distributi...more >>
Getting conflicts without changing Posted by David at 6/9/2006 3:40:43 PM Using SQL 2000 and Merge replication.
We are getting conflicts on some laptops that are not changing any data when
disconnected from publisher. When they connect to network we have windows
synch manager run a synch to get any changes to laptop while they were out.
These laptops are getting c...more >>
Upgrade and retain publications Posted by David at 6/9/2006 9:51:32 AM We have SQL 2000 server as publisher with 2 publications (tables and
views/sp). Our subscribers are laptops using MSDE. We are planning to move
to SQL 2005 server and 2005 express soon. I know I can do a full backup on
2000 database and then restore it on the 2005 server but the replication ...more >>
Setting NOT FOR REPLICATION option on relationships Posted by Ruben at 6/9/2006 9:36:02 AM Hi, I'm having a lot of problems on a filtered merge replication, because
it's deleting records. I just find out this problem is because the NOT FOR
REPLICATION parameter is not set on the FK restrictions, as far I read
setting this option will solve my problems, but my question is: Can I just...more >>
How to "register" a subscriber? Posted by dzman49 at 6/9/2006 7:30:00 AM I get the following error when trying to make a new pull subscription
to a merge publication:
~~~~~~~~~~~~~~~~
Subscriber 'HQSQLDEV1' cannot subscribe to this publication. It cannot
create a named subscription because the publication does not allow
named pull subscriptions or because it is n...more >>
internet replication Posted by Johan at 6/9/2006 12:00:00 AM Hello,
I am configuring a merge replication with subscribers that replicate
over the internet. The subscribers are outside our domain.
I keep getting an error after starting the synchronization: The Proxy
auto configuration file cannot be downloaded.
The replication works fine when I'm ...more >>
sp_removedbreplication changes server version Posted by matt NO[at]SPAM m3it.com.au at 6/8/2006 9:38:05 PM Yesterday I obtained a backup of a replicated DB and restored on my
server (no replication in use on this server).
Although I haven't had problems in the past with this DB, yesterday I
found that I couldn't make any data changes after the restore (these
changes aren't pushed back to the publishe...more >>
Change the incrment value in replicated table Posted by SouRa at 6/8/2006 5:03:01 AM Hi,
I have a replicated table, that table identity column's increment and seed
value to be 1 in publisher and subscriber.
Now we want to change the increment value in publisher and subscriber. How
to change it.
Pls advise me.
Rgds,
Soura...more >>
Concurrent snapshot processing setup raises error Posted by Lavanya at 6/8/2006 12:53:36 AM Hi
In SQL 2000 publisher & subscriber, when i try to use scripts for
setting up publisher using @sync_type='concurrent' in sp_addpublication
and then use sp_addarticle , it shows the following error:
"Cannot create article <name>. All Articles that are part of a
concurrent synchronisation p...more >>
Error in queued transactional updating replication - could not find stored procedure "upd. ... Posted by Daniel Crichton at 6/8/2006 12:00:00 AM I've been banging my head against this all morning, and can't sort out how
to fix it. I'm not familiar with the replication sps, I'm using SSMS to
create the replication, so I guess this could be a bug in SSMS. Anyway,
details time.
I've created a transactional publication with updatable su...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |