Hi, I have an application written in VB.net that controls synchronization between an MSDE(SP3) db and SQL2000-SP3. When testing the synchronization, I get error(s) regarding not being able to read a script "object". The messages are as follows: (1) \\OAKS15\...\VPInfo_1.sch could not b...more >>

From Getting Started TaskPad|Replicate Date|Configure Replication. Go through the wizard with all the defaults. Click Finish. Gives the error: "SQL Server Enterprise Manager could not configure 'SQL1' as the Distributor for 'SQL1'. Error 18482: Could not connect to server 'SQL2' because...more >>

I'm trying to set up a subscription from a transactional publication. The publication works find but when I try to push or pull a subscription to another server I get the following message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I can set up a subscription on the publishi...more >>

Hi, I get the following message 'the identity range resource available is not enough..' I have sql 2k replicating to 3 servers. I've given an identity range of 250000. The max number of rows populated in the table so far is 1358. It failed with the above error on one server at 888 rows. Rest of...more >>

Where can I find examples on automating (adding a subscription, and starting sync) using mobsync? Thanks. -- Michael Tissington Oaklodge Technologies http://www.oaklodge.com/technology ...more >>

Hi I have a successful merge replication setup between SQL2k and Access, however my access file has more than doubled in size making it almost unusable at its end of the replication. Does anyone know how to compact this file back down? If I take the two replicated tables and export them...more >>

Hello I have two SQL Server 2000 (version: 8.00.760) that is running on win2000 Servers (sp3). Both SQL servers are located behind a firewall. Problem I can set up a replication (transactional or merge) and the snapshot goes thru. The replication works fine for a couple of hours, or d...more >>

Hi all, I have more informations: my is design as: CREATE TABLE [dbo].[DB4_TPROMO] ( [ID_PRO] [int] NOT NULL , [NOM_PRO] [nvarchar] (20) COLLATE Compatibility_52_409_1 NULL , [SESSION_USERNAME] [nvarchar] (50) COLLATE French_CI_AS NULL , [NOM_MACHINE] [nvarchar] (15) COLLATE Compatibi...more >>

I am planning to use replication over the internet, but was told that replication is meant to be used over a network ? Before I start development I want to find out if replication over the internet is a reliable solution and what I need to have in place before I start. The publisher will be Wi...more >>

i understand that we need to register the remote SQL server in local server in order to perform the replication. is there any script / store procedure for me to do this task by entering the 1. user id 2. password 3. ip address or other information that necessary. as i want to make t...more >>

Hi, I have configured a Distributor and Publisher in SQL 2000 running SP 3. In this server, I have setup merge replication. This merge replication agent runs successfully inside the network when i use a network path. I am able to create and set subscriptions successfuly. Also any update...more >>

I used database maintain wizar to backup my database. After backup the transaction log, the file size of this log file hasn't been decreased. could anyone help me where do I miss something?...more >>

I am use the SQL sever 2000 to process transactional replication. Is possible to replicate the default value of a column (such as getdate()) from publisher to subscribers? Thank you....more >>

Hallo all, We have a MERGE replication set up as follows: 1) Publisher and Distributor (sql server 7.0) on the same Windows NT 4 Server 2) 8 subscribers running Sql server 7.0 on NT 4 server We want to put new subscribers which will be running Windows Server 2000 and Sql Server 2000. Is i...more >>

I have a feeling this isn't possible but.... After the initial snapshot has been applied to start the process - is there a way for the Subscriber to get the pending transactions from the Publisher/Distributor, without making a direct connection to the Distributor database? Can they be sent by ...more >>

Every new Table, Views, Objects I put in a Transactional Publisher database is not replicate immediately. And when I go into Publication properties it shows the new tables/views is unpublished and has a Lock on it.. How do I remove the lock and allow the checkbox for the new table to be publish...more >>

anyone have a script to remove all traces of replication from sql 2000 database? -- Thanks in advance, Les Caudle...more >>

Hi, We had installed a replication between two SQL Server 2000 servers a long time ago. Now, we have to modify a table, pour le replication is not active anymore for months. When we try to save table changes, a message tells us that we can not save because of the replication. Does ...more >>

Let say i create one database with one table [Organisation] and 2 fields/columns (OrgID, OrgName). I create the sql script for this database because i want to install the database to another 2 PC, that means i want to test Replication using 3 PCs [PC_A, PC_B, and PC_C]. PC_A will be config...more >>

Hi, I'm trying to stop deletes from an OLTP environment being replicated to a D/W environment. I wan't all other transactions to be replicated as normal. Is there a way to do this? W2K with SQL2000. I'm using [queued] transactional pull from D/W. TIA, SJT...more >>

Hello, I'm setting up merge Replication and while generating Intial Snapshot I'm getting this error 'This server has been disconnected. You must reconnect to perform this operation.' I've noticed that this is coming while generating Artical for big table with 3Million row..It works f...more >>

We are replicating between 2 Sql Srvr 2000 systems, going only from the publisher to the subscriber. Most of the tables have identity columns as the primary key, which is lost at the subscriber. Is it possible to replicate the original schema exactly at the subscriber for these tables? Joh...more >>

So, I have Server MyServer which is a distrubutor; I have MyDB1 as the publication; I have MyDB2 as the subscriber. Can I run queries against the articles in the subscription? If so, how? I'm trying to understand how this works. I've read documentation on how to create a Snapshot Repli...more >>

Hello all, This isn't really a replication question but i can't find info in this area anywhere else. I'd appreciate any help i can get. i was wondering about syncing databases (sql server 7.0 to CE-on a pda). is there anything in sql that handles that? on 7.0 or 2000? or do i have to...more >>

Hi All, Where can I find the detail infomation about the replication? I hope to know the mechanism of replication. On the replication what is happen to the publisher, subscriber and distibutor? Thanks ...more >>

Dear all, Is the Transactional Replication in SQL2000 an asynchronous replication? cheers, Gavin ...more >>

Dear all, During the Subscription wizard when I should chouse the Publication on Publisher Server I am not able to expand SQL Publisher Server which is named CAK5AC (Please see the attachment), so I can not finish the Subscription Wizard at all. I also checked that Login I use to login...more >>

Would anyone care to recommend a 'best' approach to the following scenario? 1) I have a production database in Bangkok which contains our picture catalog. Updates are being performed regularly throughout the day. (SQLServer 2000 sp3 on W2K both Standard Edition). The database is currently abou...more >>

We have a pretty complex environment with a several central publishers pushing to remote distributors and then many downstream subscribers all working well on sql 7.0. About to finally migrate to sql 2000 and have seen the microsoft articles that suggest we should do the distributor first, pu...more >>

Hello I'm setting up 2 servers, one primary and one secondary 'backup' server. The idea being, if the primary went down, I can switch to the secondary. I know how to setup the SQL database to 'push' changes from the Primary to the secondary machine so both are kept fully in sync. BUT, if I n...more >>

Hello How can I return a user defined Cursor from a stored procedure? thanks for any help........more >>

Hi All, I happily had replication working from a 6.5 Pub\Dist to about a dozen other 6.5 servers. One of the Servers got upgraded to SQL 7, and although it is supposed to be possible to replicate from 6.5 to 7, I also chose to upgrade the Pub\Dist to SQL 7. I have run the scripts that al...more >>

Let me know if this post belongs on the dts group. I am running sql server 2k standard with sp3 and win 2k with sp3. I am trying to run a dts package that drops a table. That table was once an article for publication with a pull subscription. I have since dropped the pull subscription and d...more >>

Hi, I need some help diagnosing this problem please. ================================ I have a development box where I have 4 Database instances each using replication of some sort. I was experiencing bizarre behaviour in some triggers simply to populate a publication article. The trigger was...more >>

I am in the process of designing a SQL Server database that will use replication, and any advice on setting up the replication would be much appreciated. < BACKGROUND > The database is a restaurant inventory control database that which is currently in Access in many separate databases, wh...more >>

Can you replicate SQL 2000 data back to 7.0, is this possible?...more >>