all groups > sql server replication > may 2007 > threads for may 29 - 31, 2007
Filter by week: 1 2 3 4 5
Rights problem after replication
Posted by pem at 5/31/2007 1:02:37 AM
Hello,
I've got a snapshot replication problem. My master database has some
tables which are replicated on 2 read-only databases. In every
database, I have the same roles, but not the same users. When I
replicate the database, every rights on my replicated tables are
erased ! What's the problem... more >>
Snapshot Agent Never Starts
Posted by pbr at 5/30/2007 4:22:06 PM
I am following "Creating a Mobile Application with SQL Server Compact
Edition" and reached "Creating the Publication Snapshot" View Snapshot Agent
Staus -> Start but the agent remains on Starting and finally times out after
10 minutes. Any pointers appreciated.
... more >>
Replecation error
Posted by at 5/30/2007 2:30:39 PM
Please help, I am getting the followng Error on my Server
[5/30/2007 2:28:16 PM]STGITDSQL.ITD: select @@SERVERNAME
[5/30/2007 2:28:16 PM]STGITDSQL.ITD: sp_MSgetversion
Status: 4096, code: 20024, text: 'Initializing'.
The agent is running. Use Replication Monitor to view the details of this
... more >>
merge replication - user (null)
Posted by Darin at 5/30/2007 2:27:09 PM
I have customer that is setup for merge replication (SQL 2000) and
everything WAS working fine. Now, they are receiving an error in the
error details of the merge agent:
Login failed for user '(null)'. Reason: not associated with a trusted
SQL Server connection.
I need to get it setup so ... more >>
New icon appears after restarting Distribution/Merge agents - mean
Posted by Rich at 5/30/2007 12:27:00 PM
Hello,
All of a sudden, Sql Server 2000 Replication has started failing for
Transaction and Merge Replication on our system. I have been restarting the
Distribution and Merge Agents and after Refresh, the Red X goes away (for a
little while). Something obviously is out of synch. But on t... more >>
merge repl sync failing
Posted by jaylou at 5/30/2007 10:49:03 AM
Hi All,
I have SQL 2005 merge repl working at about 20 branches. I just added a new
one, but for some reaon the tables and procs in the articles are not being
sent to the subscriber. I thought the agent when started will sync the 2
together. I scripted out one of my other branch repl and c... more >>
merge replication with pull subscriber(compress snapshot)
Posted by daniel at 5/30/2007 6:41:01 AM
Hi
I am trying to implement merge publication with compress snapshot, copy it
to the subscriber,
create a pull subscriber with the alternate folder(where the snapshot was
copied to)
and then run the agent for synchronization (first time).
i get error that the table in the publication does no... more >>
Regarding Bulk Copy in Transactional Replication..
Posted by Baji Prasad.B at 5/30/2007 1:21:03 AM
Hi,
I got typical scenario in transacrtional replication. i want to avoid bulk
copy during replication.
Let me explain my scenario.
I’m doing transactional replication between two databases.
When publisher and subscriber created the data going to be bulk copied from
publisher table ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Two-way merge with identity columns SQL 2005
Posted by Lawrence at 5/29/2007 4:11:00 PM
How does SQL 2005 handle Two-way merge with identity columns?
How are identity columns handled with incremental numbers?
Does the merge process prevent duplication of numbers?
... more >>
snapshot kept on re-delivering
Posted by Wingman at 5/29/2007 7:49:01 AM
We have a SQL 2K5 with sp2 as a publisher using push replication to two other
SQL servers. One of the subscriber servers is SQL 2005 and the other one is
SQL 2000. I recently made a table schema change which I increased a few
length in a field from Varchar(20) to Varchar(50). To make this... more >>
|