hello, im reading about configuring replication in books online. can someone tell me what it means when creating a publicatiion i would have to determine "the type of databases that will be subscribers to the publication"? this is absolutely throwing me off. does it mean whether it i...more >>

I use transactional replication on SQL 2000 server. Error message from Agent history: "Could not drop object 'AXC_table' because it is referenced by a Foreign Key constraint." Why the repilcation have to drop target table? How to fix this kind problem? Thanks for help. -Tom...more >>

I would like to know if the clustering under sqlserver 2000 works fine. Could you give some pointers in order to install a cluster under sqlserver ? Best regards ...more >>

We are trying to apply replication to a QA database. The Development copy of the database, on the same server, has replication already applied and working. Part of our replication script includes a pre-snapshot TSQL file and a post-snapshot TSQL file. We have made copies of these files with d...more >>

We have a script that implements replication on a database. Part of the script needs to modify the jobs created to perform the replication (we need to add custom steps to the jobs). SQL seems to add a numerical suffix to each job name, and the suffix increments by 1 each time the jobs are crea...more >>

We have transactional replication running from SQL Server 2000 to Oracl 8.1.7.3. The log reader and distribution jobs are setup to run every minutes. The following error is being encountered intermittently: The agent is suspect. No response within last 30 minutes. Our profile is as foll...more >>

How can I put a conditional in a row filter? Based on the subscriber privelege, I either want to return all rows or just the rows for the subscriber What I want to accomplish is this: if (select ViewAll from [dbo].[tblLocal] where workerID = HOST_NAME()) = 1 SELECT <published_columns> F...more >>

Hi, I'm having problems getting my subscription to work. I get this error: The process could not read file '\\WEB17040\D$\MSSQL7 \ReplData\unc\WEB17040_HandicappersCircle_BTR_Live_WatchLi st\20031212171746\tblHorseRacingWatchList.sch' due to OS error 53. The publisher is a SQL Server...more >>

We are trying to setup replication between 2 development servers in the same domain. We have had replication working before, but now when we try to set it up, the Merge agent throws the following error: Login failed for user 'NT Authority\Anonymous Login' [SQLSTATE: 28000] [Error 18456] ...more >>

I am looking for a way to find out the username and password that we are using to replicate to certain servers. I know you enter that info in when you first setup replication; however, I cannot find that information now. I would think you would just right click on the server under the sql server g...more >>

I am using Access 2000 and SQL Server 2000. I wrote a program for my salesman to create quotes on the road. At the end of the day when they are back at the office I want the information synchronized with SQLserver. Can somebody get me started with the route I should be looking at?...more >>

MS support told me to run this and now my server is super slow. Any ideas??? ...more >>

I upsized an access database using the Access wizard on my local machine and it created a working MS SQL database that is identical to the one on the remote server. Now I am trying to restore a backup made of the database using enterprise mgr on the remote server to the database on my local PC. T...more >>

Hi there, I managed to set up a transactional replication process between 2 databases and see, that in the publishing database for each article has made a systemview. What are these views for? I was hoping to setup a synchronizationprocess to keep a backupdb in case of emergency; these systemvi...more >>

Hello - I want to add a column to a table that is being merge replicated. I have the snapshot option set to "delete data but keep table" set so that stored procedures are not deleted when the subscription is initailized. Unfortunately, the column addition is not being added at the subscriber...more >>

Some shops rely on replication for disaster recovery, but have you developed a plan to protect you from replication failure, distribution server outage? How do you recover, barring rebuilding publications and subscriptions on a new box? I have transactional replication serving other database serv...more >>

From a licensing standpoint, is the following model legal? We are running SQL Server Enterprise as the production server. This machine is the Publisher. The main report server is also SQL Server Enterprise. This machine is the distributor and the 1st subscriber. Future subscribers are g...more >>

Hello, I want to read the SQL Server 2000's log file inorder to finish my task, But I can not find any information about how to do it? Thanks for help!! :) luoj@corswork.com ...more >>

Hello All, I have a SQL 6.5 server, how do I migrate the databases in my old 6.5 server to the new SQL 7.0 Server. If you have any suggestions or procedure that works please email me at lynhant@yahoo.com Thank You....more >>

we have a snapshot between two windows 2000 sql servers with sp3 all of a suden it has failed with The process could not bulk copy out of table '[dbo]. [syncobj_0x4433423232433036]'. The step failed. Has anyone else had any similar problems or know where I would look to to solve this prob...more >>

Hello all I am new to replication and I am doing a simple pull subscription between two servers. Is is possible to set email or other notification if any of the scheduled 'pulls' or various agents fail. Perhaps I have to use Raise Error? Thanks for any help Alice S ...more >>

Sir, I have to replicate database updates from Server A to Server B. I have configured to connect database server A to database Server B by dial-up networking which has a distance of 5 kilometers between them. I have a job schedular which connects database Server A to database Server B at 10...more >>

I am looking for a query (or simple stored proc) to return the max value for all my identity columns ( MAX(IDENTITYCOL) ) in my database. I would like this query to be dynamic in that, I do not need to specify the table names or the column names. If not, I guess could I iterate through the ta...more >>

We have set up transaction replication between 2 servers. There is TLog growth intially and it's growing. We are doing Log backup every hour, recover model is FULL. Let's advice me. Thanks and Happy Holidays. John....more >>

Hi! I have a problem trying to setup merge replication with multiple publishers, one central subscriber. Publishers are MSDE2000sp3a, subscriber is SQL2000sp3a. Setup and initial snapshot worked fine. Then I re-initialized one the subscriptions, and got this message when the snapshot was lo...more >>

We are running a continuous merge replication process using SQL2K Personal Edition (SP3a) on a W2K server as the publisher with 12 subscriber W2K/SQL2K(SP3a) servers. Does anyone know if there is an inherent limit to the number of subscribers possible? We are receiving the following mess...more >>

Hello, We have a case where desktop applications running on MSDE 2000 will be installed on remote locations. Some tables of these databases need be replicated on a central location where a SQL Server 2000 resides. The msde 2000 installations are geographically dispersed and the physical...more >>

I have successfully implemented Log Shipping on SQL 2000. Everything runs smoothly, however, I have concerns about the best way to shrink the Log File on the Destination db. Is there a way to run a DBCC SHRINKDATABASE or something similar on the Destination db? Because it's in Read-Only mode, t...more >>

I need to replicate some Oracle data on to some Pocket PC sqlce databases. Can't use Oracle Lite because I am using the compact framework on the PocketPC and Oracle doesn't have a driver for Oracle lite on .net compact framework yet. Also the Oracle replication stuff is real buggy. Is t...more >>

Bonjour, Je viens vers vous pour un problème de réplication SQL Server 2000 -> SQL Server CE. J'ai crée une publication de fusion dans SQL Server. La réplication se fait correctement la première fois entre les PDAs et le serveur mais je n'ai aucune mise à jour qui se fait aprés alors que mes ...more >>

Hi all, I have setup a transactional replication between 2 servers. Everything worked fine till now when the distribution agent returns this error: Error message: The process could not bulk copy into table '"table name"'. Error details: General network error. Check your network documentation...more >>

Hello I'm using Microsoft SQL 2000 SP3a Standard Edition on Windows 2000 SP4, and I'm trying implement SLS. For those who doesn't know what SLS is I found it on Microsoft SQL 2000 Resource Kit (you can read more info there) basically it's a simplified version of Log Shipping feature that comes...more >>

First, here is the configuration: - Publisher with two subscribers - A snapshot created over 1 year ago - The second subscriber was successfully added this past weekend - It has been noticed that the Snapshot from 1 year ago is woefully outdated. This required a very LOONNGGG time for th...more >>

Sorry about the previous message. I inadvertantly hit SEND before it was finished. Setup: - MS SQL 7.0 (SP2) - Windows NT 4.0 (SP6a) - Merge replication with one publisher and two subscribers After running conflict free since early October, today I got a bunch of merge conflicts on four ...more >>

asdfsdfsad g fg ag a...more >>

We have a situation where we are log shipping from the prod server to a report server every 15 minutes. However, as the logs are being applied to the report server DB, the DB is not available for a brief period of time. Most of the time it is just a few seconds, but it has taken up to 2 mi...more >>

Hello, I have a problem. I try to restore a backup from a SQLSERVER7 base to an other SQLSERVER7 base. The command I use is the following one : USE MASTER GO RESTORE DATABASE NomBase FROM DISK='C:\MigSQL02\MYBASE_db_200312081146.BAK' WITH MOVE 'MYBASE_Data' TO 'D:\MSSQL7\Data\Mybas...more >>

Hi! I need to do this: 1 SQL2000 server in central office 10 remote MSDE2000 servers in stores with daily sales data. The current data in the stores and the new daily information must be sent to the central server for reporting and accounting. Records are identified by a store number fie...more >>

When running the newly created (no snapshot) push subscription distribution agent I get the following error: "Cannot load the DLL replsetoriginator extended procedure, or one of the DLLs it references. Reason: 126 (The specified module could not be found.)". The publisher is on a WinNT 4/SQL...more >>

Hi All, I disabled replication from my database, and it was successful. All the conflict tables stayed in the database. Is it OK to drop all these tables? Now that I am not using replication anymore I dont need them. Also the subscription to my other server is still there and I can't ...more >>