|
|
|
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 SQL 2005 cannot subscribe to SQL 2000 Publication Posted by Aubrey at 3/31/2007 7:26:01 PM How do I / Can I use SQL 2005 Express Edition to subscribe to a SQL 2000
Publication?
I attempted to use Windows Synchronizer to create an Anonymous Merge
Subscription on a Laptop running Windows Vista Home Premium with SQL Server
2005 Express Edition. It 'complained' that SQL 2005 cannot s...more >>
Can this direction of merge replication be specified? Posted by Oskar at 3/31/2007 10:36:01 AM Hi,
In whatever version of SQL Server 2005, can I make merge or any other type
of replication to replicate data only from subscriber to publisher (only
upload changes)?
-- Thanks, Oskar.
...more >>
Merge replication row filter Posted by JC at 3/31/2007 10:07:05 AM I have a situation which I can't seem to find an answer to. I have
merge replication set up in SQL2005 and everything seems to work find
except that the row filter for a table isn't working 100%. I have 200
or so field guys who have SQL Express installed on their laptops who
syncronize data back...more >>
Comparing database structures Posted by Earl at 3/30/2007 10:10:08 PM I'm trying to evaluate the RedGate SQLCompare tool and it did a nice
comparison between an up-to-date version and an older version of the same
database. However, when I try to synchronize, it synchronizes the normal
tables, then I get a message:
The following error message was returned from...more >>
Invalid character value for cast specification/other errors Posted by Doug at 3/30/2007 10:20:00 AM We are on SQL Server 2000 SP3
We are trying to get to SQL 2005, but cannot do that until we consolidate
our databases so the upgrade will complete in a reasonable amount of time.
I am trying to use bcp to copy data out from each database and move it
into a centralized database. Of the 1...more >>
Subscriber record is missing from subscriber DB Posted by Leon at 3/30/2007 9:14:04 AM Hi All.
SQL Server 2000, merge replication
Record created by subscriber on subscriber DB (has ID not in publisher
range) exists on publisher but on subscriber. We are using upload and
download as a separated in time processes. Subscriber definitely
re-subscribed at one point of time (got...more >>
Replicating one table to another table (with different structure) Posted by vsp at 3/30/2007 4:38:03 AM I have 2 databases and plan to user transactional or snapshot replication to
replicate data from db1 to db2. db1.table1 name char(20), addr char(500) and
db2.table2 has entity char(20), addr1 char(100), addr2 char(100) etc.
Table Names & column Names and different but type remain same.
Can...more >>
EXACT sequence of events in sync mirroring Posted by Methodology at 3/30/2007 1:18:03 AM Hi
I need to know exactly the sequence of events in synchronous mirroring mode.
What im reading is this:
1. tranaction recved from a client by primary
2. primary writes trans to trans log
3. log written to dbase ie to disk from log on primary and concurrently
sends log to mirror.
4. Pri...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
what is a Merge Conflicts ? Posted by Ravi Lobo at 3/29/2007 6:04:03 PM How does conflicts happen in merge replication? Whether it is
a) rows updated at the SAME TIME at different subscribers?
Or
b) synchronization is not depend on time but depend on when you
synchronise it ?
...more >>
Merge replication re-initialization Posted by Ravi Lobo at 3/29/2007 5:56:00 PM I have 2 questions,
1. In what circumstances a subscriber need a re-initialization?
2. When I re initialize the second time, Does it re applies the whole
snapshot to the subscriber again or applies only the delta corrections?
...more >>
Setup Merge Publication from Scratch Posted by bt7403 at 3/29/2007 4:14:01 PM Just installed SQL Server 2K5 SP1-default install-using local acct-copied new
db from another server-configured snapshot and merge agent using impersonate
SQL settings ok-ran snapshot ok-ran merge agent and saw this in Monitor
details
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'-error...more >>
replication error Posted by shunyen at 3/29/2007 4:05:02 PM we are replicating from SQL 2000 to Oracle via linked server. and are
getting the following error "The process encountered invalid column
data in bcp file", the bcp file is too big to investigate it, any one
has any insight of this?
...more >>
Add Index to a Published article Posted by Steve at 3/29/2007 12:56:07 PM How can I add an index to a article in a Merge publication and have that go
to the subscribers?
Thanks,
Steve...more >>
Merge replication - schema change. Am I in trouble? Posted by Rafael Lenartowicz at 3/29/2007 12:35:16 PM after update from 2000SP4 to 2005SP2 I noticed two stored procedures having
issue due to changed functionality of the @@IDENTITY vs. SCOPE_INDETITY(). I
changed them on the publisher/distributor and regenrated the snapshot before
marking subscriptions for reinitialization. Next sync supposed t...more >>
Expiring and Reinitializing Subscriptions Posted by Crash at 3/29/2007 10:58:18 AM Publisher: Windows 2000 SP4
SQL2005 SP1
Subscriber:SQL Server Express
Tablet XP SP2
If I have a subscription retention of 20 days and a subscriber never
misses a 20 day window; aka they never "expire" because they always
replicate within the retention period, what happens to the replicatio...more >>
Programmatic synchronizing and metadata Posted by Car at 3/29/2007 10:56:02 AM Hello,
I created a subscription programmatically so I have the
CreateSyncAgentByDefaut property = false. Do I have to do some additional
functions to work with and clean up the subscription metadata.
Thanks for your help.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |