Successfully transfered logins and passwords using script from ms note 246133. Logins are in sysxlogins table on destination server, however, I cannot see users in the enterprise mgr for the master or other databases. Is this a problem? Do I need to manually do anything else. thanks....more >>

Hi guys Hopefully someone can answer this query for me I am quite new to working with SQL Server and I have been asked to replicate a database between 2 sites. After looking at the options I decided that Transactional Replication was the best option so I proceeded to set it up. Every...more >>

Hello, I am just started in this, but I am interested in what in spanish is called "duplicacion de instantaneas", I dont know the proper trasnlation to english so I will try t explain it. This allows to sincronized a pasive database on the server with the active database on the client who is r...more >>

All servers SQL Server 2000 SP3, no hotfixes. SMP system. Transactional replication, immediate updated. Distributor & Subscriber are same systems. I had a logreader fail permanently: Could not execute sp_replcmds Error: 9004, Severity: 23, State: 1 An error occurred while processing the log ...more >>

I have a client that is experiencing repeated non-convergence in one (out of 130) articles in a merge replication database. Several identical schemas are being subscribed to in this environment and the same article is causing trouble in each one. Here are some common elements: 1. The arti...more >>

I am using transactional replication with some subscribers as queued updateable subscribers. I have a post snapshot script which queries the permission table on the publisher and applies the permissions to the local objects on the subscriber. (This is to get round the probelm of role permissions...more >>

Hi! I have a Publication with a table holding data for four different regions viz North, south, East, West. I have different subscribers requiring data pertaining to their region. I know that I do not need to create multiple publications for this task in SQL2000. I'm using Transactional...more >>

I have two servers running SQL Server 2000 under Windows 200 Server. Server 1 (being setup as the Publisher and Distributor) has Server 2 as the Subscriber. When I complete the Configure Publishing, Subscribers, and Distribution Wizard (the Publisher is defined to be Transactional and th...more >>

I am using W2K SP3 and SQL 2000 SP2 and performing snapshot replication between 2 servers. My destination server is using a pull subscription and is run twice per day. Every article is set to drop the existing table if it exists and re-create the table. My problem is that the destinatio...more >>

Using transactional replication, create and drop index commands do not get replicated. Is this normal transactional replication behaviour? Thanks....more >>

We are running SQL7 on both boxes, it's an intranet environment, we have two servers running Windows 2000 Server about 100 miles apart. I have set up a transactional publication to push a pub of a DB from our production server to a standby "failover" server that is in a remote location. It'...more >>

Hello, I am trying to restore the distribution database. I get an error that reads "Exclusive access cannot be obtained because the database is in use. RESTORE DATABASE is terminating abnormally.". The SQL Server Books Online tells the following about restoring distribution database. "When r...more >>

If I'm replicating a server with 4 instances on this server. What's the best way to move the users with it, without deleting and recreating them?...more >>

We're using Merge Replication with SQL Server 2000 SP3. I'm getting alot of the following messages. 17120: SQL Server could not spawn process_loginread thread. Does anyone have an idea what this is related to? TIA, Doug ...more >>

Hello all! We need to find out what the name of system procs that generate sp_Ms procs for replication? because these system procs not generate sp_Ms procs correctly for table with identity type. Do we know if this has been corrected with the next release? Thanks in advance...more >>

if you are setting up the standby server via tape restore from the original.. and in the meantime users are still entering data to the original svr.. will the translog process pick up those change made in the interim when it starts running? Also when doing the failover, and applying the...more >>

We have two MS SQL 2000 servers DB1 and DB2. DB1 is a subscriber DB2 is a publisher and a distributor replication type: merge Both of our servers run on Win2000 sp4. Yesterday we installed a sp3a for MS SQL server. The installation was made simultaneously for both servers. T...more >>

Replication is failing from one server. The history viewer says, "The RPC Server is unavailable. NOTE: The step was retried the requested number of times (10) without succeeding. The step failed." What causes this? Thanks, Steven...more >>

Hay, I'm working on a project using merge replication, sql ce and gprs, and i want to track the size of data transferred during synchronization (i.e. how many kb is transferred during a merge). I've looked around, but I can't find anything related looking through the merge agent history... Sh...more >>

I added a new field to a table that is currently being replicated. I didn't think I had to drop and re-add the subscriptions for a change like this? I thought it was only if I had added new tables or things more significant like that? so replication succeeded but the newly added field was not ...more >>

I am trying to write a SP to use as a custom conflict resolver. I am following the example code in avgprice.sql, but am running into a syntax error in the example code. The place I run into the problem is a modification of the example line: SELECT @select_string= 'SELECT * FROM OPENQUERY('...more >>

how I can stablish a trusted connection between 2 computers. one w2k/sql2k, and other w2k/msde?? Thanks ...more >>

Hi, my name is CJ and have one problem with replication, the error is: could not connect to server 'name server' because 'distributor_admin' is not defined as a remote login at the server. thanks. ...more >>

Hello all, I'm upgrading our SQL 6.5 database to 2000. The 6.5 server is replicating to two servers that I would like to leave untouched as much as possible during the upgrade. When I upgrade the database on the new server, all of the publications and replication related tasks upgrade successfu...more >>

Ok situation is like so; I run a website from a SQL2k cluster. However, I wish to replace the entire hardware set up (array and everything). I wish to keep the down time to an absolute minimum. Therefore I'm considering installing the new cluster alongside the old one and setting it as a warm st...more >>

We are replicating data from one SQL database to a different SQL database (on the same server, MS SQL 2000). For this, we use Transactional (Push) Publications and DTS packages (with data driven queries and ActiveX script). In the 'old' database, we have one table witch data goes into two ta...more >>

Hi , I am srikanth and working on merge replication with pull subscriptions. We have windows 2000 server on which the distributor and publisher is configured. We have three publications and using join filters. And the problem is synchronization is working fine over cable net or T1 lines, Bu...more >>

I have transactional replication set up with push subscription and then removed with replication disabled at the publisher through the Enterprise Manager and SQL Service was restarted. Publisher was dropped from the list of publishers at the distributor. I have to add that the main reason...more >>

Hi, I am new to this newsgroup. Would anyone share me where I can find information about replication on the web, so I can learn them? Thanks. ...more >>

My pilot site users are experiencing problems with replication from SQL Server to their PPC devices this morning. Environment -- SQL Server 2000 SP3, Windows 2003 Server PPC2002, .Net CF SP1, Sql CE 2.0 SP3 SQl Server has hotfix from KB814916 error We observe a timeout after 5 minutes ...more >>

We want to completely replace our SQL Server with upgraded hardware. Can someone point me to a white paper or KB article on the procedure (assuming there is one) for do this properly? My experience with replication is that replicating databases are very finicky about being restored or attached...more >>

Please assist on giving me the complete(!) list of required TCP ports to be opened in the firewall between our Publisher and Distributer/Subscriber! My assumption was that only ports 1433 and 445 (preferrably only the latter but that does not seem possible) need to be open in the firewall...more >>

hi, i have configured transactional replication(Using the Push Subscription at the source) between SQL Server 2000 (Both Publisher and Subscriber).Once the replication is done,the replication agent is stopping(In SQL Server Enterprise Manager >> Replication Monitor >> Publishers >> SQL ...more >>

I posted this a week ago on the MSDE group but haven't received a response... I've set up (merge) replication using MSDE on 3 XP machines. I'm using push subscriptions because each machine frequently updates its local subscription db and the changes are then continuously replicated. M...more >>

We have set a Transactionnal replication (Using SQL server Entreprise Edition 2000): The subscription type is push. The replication is done through the Internet. Every time the internet connection is down the replication is stopped. So we need to create it again or reinitialize it again. We...more >>

Using simple logshipping. Tested failover successful, now I need to add the users/passwords that are in my master db.. Do I restore the entire master db or is there a way to extract user info so all users can login to the failover server? Thanks....more >>

Hi, I'm trying to diagnose a merge replication perf. issue. I have a merge publication (sql2k sp3) with sql ce 2.0 subscribers. There are 2 main tables which have quite a lot of churn within a day or two. In the region of 50- 100 '000 records / table / day. My problem is that we're seei...more >>

I have 2 SQL Servers running, 1 development server and 1 production server. Until now I have used SQL Compare to keep my database structure in sync, and I use SQL DataCompare to keep the data in some of my tables in-sync. I transfer data from the sysdtspackages table to keep my DTS packages updat...more >>

Hello, Consider a transactional replication of several tables. On the publisher side all tables have primary keys. On the subscriber side these tables do not have primary keys but an = index instead. I asked the dbo why there are no primary keys on the subscriber side and = he said these are...more >>

How can I run replication on demand? We have a laptop that connects to our network via dial up once a week and would like for the laptop to activate the replication process once connected to the network. Another question. Can I run a replication job with a vb script? Thanks ...more >>