|
|
|
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 HowTo: DDL replication only, no data ? Posted by mEmENT0m0RI at 5/21/2007 11:21:51 AM I'm trying to keep my QA environmens in Sync. Is there a way to only
transfer the schema changes
without data?
Thanks,
Igor
*** Sent via Developersdex http://www.developersdex.com ***...more >>
sp_helpdistributor no rows Posted by Boudicca at 5/19/2007 4:21:04 AM Hi All
I have an application that correctly sets up a publication on a SQL2K
database and we are now in the process of testing the same mechanism
against a 2005 database but we have hit some issues.
I'm executing sp_helpdistributor in SQL2005 but no results are being
returned using the quer...more >>
how to detect transactional replication agent failure programmatic Posted by FJY at 5/18/2007 3:58:01 PM Hello,
Right now, I have an alert set up in the SQL Server but is it possible for a
C#/C/C++/VB program to detect the replication agent failure? If so, how can
it be done?
Thanks in advance,
Frank...more >>
Latency Scale Seconds or Milliseconds Posted by Alpine7 at 5/18/2007 11:55:46 AM In SQL Server 2005 we are running transactional replication across a
LAN. If we insert a trace token we see latency of 00:00:05 is this 5
seconds or 5 milliseconds.
thanks.
...more >>
Altering a column on a NoSync Replicated Table Posted by BaniSQL at 5/18/2007 10:45:00 AM Hi,
I saw an article on www.replicationanswers.com, about Altering a column on a
Replicated Table (from Paul Ibison):
exec sp_dropsubscription @publication = 'tTestFNames'
, @article = 'tEmployees'
, @subscriber = 'RSCOMPUTER'
, @destination_db = 'testrep'
exec sp_droparticle @publica...more >>
Clearing out snapshot folders Posted by David Gray at 5/18/2007 12:00:00 AM
Hi,
Windows Server 2003
SQL Server 2000
Can anyone tell me how I can get rid of the snapshot replication
folders at a pre-defined time? We do snapshot replication at approx
03:00 and would like to get rid of the ReplData\Unc\xxxxxxx folder at
approx 06:00.
We fire off our replic...more >>
Do triggers fire in the mirror database? Posted by Steve Troxell at 5/17/2007 11:08:01 PM Prior to today, I've done nothing with mirroring. Two of us have
independently setup a mirroring scenario with triggers in the principal and
mirror databases. The triggers write to a separate, non-mirrored database
(identical copies on the principal server and the mirror server).
In both ca...more >>
Million records table Posted by l.coronati NO[at]SPAM p3italy.it at 5/17/2007 2:23:18 AM Hi everybody,
I set up a merge replication on Sql2K with one publisher/distributor
and 6 anonymous subscribers that run msde.
The db is growing bigger and bigger and i can't understand why.
I noticed that some of the MS_xxxxx tables are very large: in
particular one is 16.7 millions and another...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
2000 sp4 merge agent failure: The process could not make a generat Posted by John T at 5/16/2007 3:06:00 PM Hello,
SQL2K4, SP4, W2k3 SP1. When I start up my merge agent, I get the following
error:
The process could not make a generation at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200994
--------------------------------------------------------------------...more >>
Snapshot replication Posted by cata at 5/16/2007 6:45:00 AM I have a snapshot replication that runs over the night and it takes about 1
hr. The issue that I have is that is locking people out of the system until
the snapshot finish.
Is there a way to eliminate this or do I have to look for other ways to
replicate the data? Would decreasing the -BcpB...more >>
backup situation scenario Posted by luna at 5/15/2007 4:29:28 PM were are planning some risk management to complement the procedures we have
in place,
we currently have an sql server (2005) and we plan to have another server
that we can take off site and bring back to site every friday for an update,
what would be the ideal solution in this case to mirror t...more >>
Replacing a view in merge Posted by David C at 5/15/2007 3:05:33 PM We have SQL 2005 and I need to update a view used in a publication. The
views are in a separate pub so it should be pretty easy. My thought is that
I run sp_dropmergearticle, update the view and then run sp_addmergearticle.
Am I correct? Also, will the subscribers get the new publication/sn...more >>
Merge Replication to multiple servers losing data Posted by PaulW at 5/15/2007 1:05:10 PM Hi,
We are using merge replication between four servers (1 publisher & 3
subscribers). The same articles (tables) are in each publication. I run the
application which changes data in some tables and adds records in another
table. The inserted data is immediately updated via trigger. After ...more >>
transactional replication with nosync init ..delete statement conf Posted by BaniSQL at 5/15/2007 3:52:01 AM Hi,
I'm having problem which previously was solved by enabling flag 8207, but
now again even with this trace flag 8207 setting On the error I'm getting
again (DELETE statement conflicted with COLUMN REFERENCE constraint 'FK__).
The only change is that the new server where I have re-setup the r...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |