|
|
|
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 MSDTC Issue Posted by Jonas Larsen at 5/31/2006 11:03:01 PM Guys
I have an updateable transactional Replication. It works fine from Publisher
to Subscriber but when I try to update a table on the Subscriber I get the
following error:
Server: Msg 8501, Level 16, State 1, Line 5
MSDTC on server 'SERVERNAME\INSTANCE' is unavailable.
Server: Msg 7391...more >>
Trans Replication question Posted by Hassan at 5/31/2006 7:39:30 PM Say i want to setup trans replication of DB1 on ServerA to subscriber DB2 on
ServerB
I already have a publication with a few articles being published now.
I want to create 2 new tables with millions of rows and want to replicate
those. Instead of adding it to the same publication and havin...more >>
Implicit conversion from data type text to nvarchar is not allowed Posted by Jonas Larsen at 5/31/2006 5:03:01 PM Hi guys
I currently trying to setup transactional updatable replication between a
server in Australia and one in France.
All goes according to plan until I begin pushing the subscription to the
France server. After awhile (Say 30 min or so) I get the following message:
Implicit conversion...more >>
Auto Number effect Posted by gurvar at 5/31/2006 2:26:01 PM Hi
I have a old database A which need to be exported,
made changes like including some columns/delete columns etc
and imported again (basically changing MetaDB) as database B.
Question is what will happen to the Auto number generated fields?
Database A has Auto fields ID starting at 134,...more >>
The process could not execute 'sp_replcmds' on 'servername'. Posted by Frank at 5/31/2006 10:20:02 AM An invalid datetime value was encountered. Value exceeds the year 9999.
I'm running SQL Server 2000 Transaction Replication. The replication has
been running without issue for 377 days. This morning I got the following:
Error Message:
The process could not execute 'sp_replcmds' on 'server...more >>
A general question on disaster recovery Posted by Fei at 5/31/2006 8:50:02 AM What's the best automated way to setup a disaster recovery environment in our
situation?
We have a production sql 2000 database receiving orders. If the machine
crashes, we would like to use another server box to function ASAP (about 0.5
to 1 hr latency is tolerable). Shall we setup a rep...more >>
Dial-in Replication process Posted by Winanjaya at 5/30/2006 10:59:02 PM Dear All,
I want to implement replication with centralized subscriber topology (1
subscriber at HO with 5 publishers in 5 cities), I had problem with 2 cities
(A & B), currenty they have not on-line network connection to HO, I thought I
want to setup dial in connection for each server (A & ...more >>
sql 2005 snapshot of mirror? Posted by togbabe at 5/30/2006 10:28:10 PM Can anybody tell me if it is possible to make a snapshot (not a log
shipping or replication snapshot. The new 2005 snapshot) of a mirrored
database even though the mirror ends up is held in a 'continually
restoring state?'
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Transactional replication synch error Posted by Koni Kogan at 5/30/2006 6:08:12 PM The tables in the publication and subscription dbs are identical. This
seems like an old bcp 'unreadable' characters problem... Anybody help?
Error messages:
The process could not bulk copy into table '"dbo"."eh_RetailSales"'.
(Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: ...more >>
Moving a replication to a new server Posted by jaylou at 5/30/2006 6:47:02 AM Hi all,
I am in the process of migrating to a new server for my production. I have
a few tables that I replicate to another server from this server. Should I
restore my Distribution DB over as well as all of my other DB's? I will be
renaming this new server to the old servers name and chan...more >>
Error 14150 in SQL Server Logs Posted by Wilma at 5/30/2006 2:17:02 AM Hi,
In my SQL Server Log the following message occurs:
"Error: 14150, Severity: 10, State: 1"
This occurs every time the distribution agents runs and there are no
replicated transactions available.
I know it's an informational error, but it annoys me. The strange thing
about it is that the...more >>
how to add column in the table that it is being used for replication. Posted by ´ý at 5/30/2006 12:00:00 AM
...more >>
How making Schema Changes on Publication Databases In SQL 2000 sp4( NOT IN SQL 2005) Posted by ´ý at 5/30/2006 12:00:00 AM
...more >>
Can subscribed table support partial replication with localization Posted by HardKhor at 5/29/2006 7:33:01 PM Hi experts,
I am currently using SQL Server 2000. My system uses replication is
synchronize the data between HQ and the branches. Can SQL Server 2K support a
partial replication of the columns in a published table?
Partial replication means to replicate only some of the columns in a table ...more >>
sql2000 server and MSDE Replication Posted by jongwoo at 5/29/2006 5:38:02 PM Hello.
I will construct client application with MSDE.
I face with a difficult question.
It's in sync with SQL2000 Server and MSDE.
Client number is 5000.
I fall in a dilemma. Which do i use, Replication or to make DB Sync
application ?
Thank you
jongwoo
...more >>
Merge Agent Continuous Mode Posted by Davec at 5/29/2006 5:53:03 AM Hi all,
I have set up 10 subscribers each with merge pull subscriptions. the
polling interval is 60 seconds and the StartQueueTimeout 120 seconds.
I have limited the number of concurrent merge processes to 5 however
the problem is that it seems the 5 that queue up never get a look in
even e...more >>
NOT FOR REPLICATION usage Posted by maxzsim via SQLMonster.com at 5/29/2006 1:16:51 AM Hi All ,
I read from BOL abt this NOT FOR REPLICATION is uses primarily for identity
values.
I have the following situation
I am creating a trigger that actually updates/insert records into tblA in
DB_A but this tblA is involved in replication to tblA in DB_B so should the
"NOT FOR RE...more >>
The merge process could not retrieve generation information at the Subscriber. Posted by Kelvin.Stella NO[at]SPAM gmail.com at 5/29/2006 12:49:36 AM Dear All,
Our system is built-in SQL 7.0.
I had one publisher and 3 subscription in 3 different location.
And recently one of the subscription got the erorr "The merge process
could not retrieve generation information at the Subscriber."
sometimes.
Can anybody advise how I can do ?
An...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |