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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

I need to use AS400 source as Publisher and SQL Server as subscriber. Can I accomplish this in SQL 2000 and 2005?...more >>

Senario I have a SQL Server 2000 SP4 that is Publisher and distributor plus a SQL Server 2000 SP3a that is a Publisher. There replicates to 2 SQL Server 2000 SP4 over the company WAN. After a roughly 10 min long network failure the queue reader agent will not start. Any ideas? Thanks...more >>

HI All, We have transactional replication(not updatable) between 2 databses on the same server (sql server2000). Our requiremnt is to prevent the deletes to go to subscriber db. So, while setting up transactional replication entered NONE in article commands properties tab for DELET...more >>

Hi all, We're in the process of investigating several HA solutions for SQL Server. We currently run a small database (couple GBs) but needs to be available for 99.99% of the time. We can tolerate some downtime... but preferably none. A coworker suggested we take a look at Double-Take due...more >>

We have 3 SQL 2005 Servers which are in a peer to peer replication topology but would also like to use merge replication to some remote clients. Is it possible to have a database peing published in peer to peer and merge replication on the same server....more >>

Hi everyone, In the SQL2005 SP2 readme file says that to install in a replication topology (merge) it has to be done in the following order: 1.. Distributor 2.. Publisher 3.. Subscribers I have a single server acting as publisher/distributor and around 19 subscribers (merge replicat...more >>

I have a question regarding functionality with SQL 2000. In 2005, there are several sys.dm tables that provide information regarding the database/OS/Hardware ect... I can use these tables to check the status of replication amoungst other things. I know SQL 2000 does not have these tables...more >>

We are really missing the sql agent that was in SQL 2000 for automating our replication, but he have created a work around application now. However, now I have found the sync center in Vista and scheduled a sync. It started the sync at the correct time, but it asked for the publisher/di...more >>

I have an access database that I want to transactionally replicate into SQL Server 2000. Can someone point me in the right direction for getting the source connection in enterprise manager? Or a brief example o how to start this? Have looked at SQL to SQL, but not Access to SQL. Thanks John ...more >>

Hi We have set up Transactional Replication between two servers. However the linked server that is created at the subscriber does not work be default. I therefore selected the last option "Be made using this security context" and entered the sa username and password. This solves the pr...more >>

Hi, Currently our core system runs on OpenVMS with the data stored in Oracle Rdb (that's not RDBMS). Rdb includes a product called LogMiner which unloads the days transactions from the transaction logs (After image journals in Rdb parlance) into a delimted file, the structure of which ...more >>

We are using SQL Server 2005. I would like to replicate our production database to our development database. The trick here is that I do not want to delete any new tables in the Development database that have not been released to production so I can't use a straight database copy. How can I...more >>

I have a the following scenario: - A transactional publicaction "TRN2000" (in SrvSQLServer2000 server) - A push subscription to "TRN2000" publication(in SrvSQLServer2005 server) - A merge publication "Merge2005" defined in SrvSQLServer2005 over the same Database/tables that transactional su...more >>

Publisher/Distribution job was removed but on Subscriver was not, since then we are not able to remobe Pull job without Subscription publication database on Subscriver server, any help how to remove it?...more >>

Hi, I'm new in SQL 2000 Replication, hope the guru's can help on my following query. a) Is the replication produce log file? b) If the answer is yes, where can i get the log files & what's the name of the log file c) Will the log file grow rapidly? d) What's the recommended book / site to r...more >>

Hello All, I am new to this group. I am looking for a tool that will convert cognos OLAp cubes into ms OLAP cubes. Anybody has an idea? Thanks a lot Angie.....more >>

The situation I am faced with is we have a web application supported by a SQL 2000(sp4) database that resides on a limited bandwidth network. Our distributed users are constantly complaining of "slow" response times. Our local users have no such complaints. Some of our leadership has sugges...more >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

Summary: Started replication April 1 of 4M xact / day publishing system to subscribing system. Performance was good. Latency was ~ 5-7 seconds. May 10 we noticed that the DB was behind (latency was 12 hours). All performance cou...more >>

HI, currently publisher and distribution is in sandiego and 8 subscribers is in losangeles. this weekend we are planning to do reindexing on all the servers.but at the same time we are planning to move distribution from sandiego to losangeles so that we dont see any delays from distribution t...more >>

Can anyone tell me if it's possible to manually configure log shipping in SQL2005? Our scenario: We would like to use our STANDBY server as a QA server and then roll the updates/changes/etc. into our PRODUCTION server via tran logs from the STANDBY server. Because of the size of our data...more >>

We have a database on SQL Server Express which is a subscription to a database on a SQL Server Workgroup. When main database (publication) will rise 4Gb, could we sincronize it? or the 4Gb limit of Express edition will not allow it? If it will not work, what should I do? Buy a Workgroup ver...more >>

Hello All, I have a pair of replicated databases. Data comes from my publisher into the subscriber, which fires a customised repl stored proc, which inserts data into a different table, that is then replicated back to the original database. My first replication is working. Data is getting i...more >>

Hello, I have a Server with 4GB of RAM and 2 64-Bit Intel Xeon Processors. I have about 400 GB of Free Hard Disk Space on a RAID 5 SCSI Hard Disk. I am attempting to do snapshot replication to a remote server. Every time that I start the job, the server goes to a crawl. There are no in...more >>

In my company, we have a central database and 4 remote databases. the central database replicate same database into 4 remote database in parallel. the replication is transaction replication and the data is input in the central database and replicated into remote databases. there are some tr...more >>

We are attempting to set up transactional replication publication, all parties using SQL 2005 Developer Edition with SP2. Right now there is only one database with only one table that's being published (@261 records, database size @221MB). Size is due to the data being mainly multimedia files su...more >>

Hello, I would like to know if instead of running sp_addscriptexec at the publisher in a merge replication architecture, is possible to run a .Net program to create the indexes at the subscriber during the installation. Thanks for your help, car....more >>