I make a Transactional Replication,when I build the snapshot,a error occu Error Message The process could not bulk copy out of table '[dbo].[syncobj_0x4636333942323233]' Error Detail Invalid time forma (Source: ODBC SQL Server Driver (ODBC); Error number: 0 and the script of view of [dbo].[syn...more >>

How can i re-create an alread push subscribtion that was deleted but before that i want to get the data from the subscription server before the main server send his data? Samir R. Ibrahim ...more >>

Hi there, I have a very serious problem with Merge Replication! My customer has one Publisher and 45 Push Subscribers, all on Windows 2000 and Sql2000 SP3. I have noticed that conflicts that were logged and viewed (not resolved) are lost after a few days. Upon investigation I found that the con...more >>

Does anyone know the reason for the error message "The process could not connect to FTP site xxx" I can connect fine using FTP, but my subscription agent generates this message. Ideas? Darryl Pollock ...more >>

Where do you specify the ftp location for the publication at the subscriber? Or is this determined by the publication properties? ...more >>

I'm trying to setup replication over the internet using FTP. I have created a SQL Login to SQL Server to use for replication (unless I'm missing something this is an absolute must). I can create an anonymous subscription using the above login provided it has access to the actual database. ...more >>

hi, i'm new in replication of database. i've 2 cpu. cpu A as main sql server publisher/distributor and cpu B as subscriber. i already publish 2 table on cpu A and set cpu B as subscriber to pull 2 tables on cpu A and insert into cpu B. but it failed with error message 'the proces could not conn...more >>

I've got this error message when trying to create a subscriber from a publisher through VPN in a non-trusted domain, I am using SQL server authentication: The schema script '\\MERCURY\G$\Program Files\Microsoft SQL Server\MSSQL$MERCURY\ReplData\unc\MERCURY$MERCURY_Northwind_NorthwindMercur...more >>

Hi, I'm relatively new to SQL. I have a it set up on 2servers. Windows 2000 Server, with SQL 2000 Standard on server1 and server2. Server 1 has a live database, which is backed up nightly. I want to take that nightly backup, and load it onto server2. I want this to occur every night, so se...more >>

Hello all, I'm rather new with replication, and I have a question. I am setting up a database (sql 2000) for transactional replication. We want it for an immediate failover, in case of disaster on the main db. An up to the minute exact copy of the original database is what we need. I've been...more >>

I have to break and restart replication and I wanted to try and start it up again with a script. Is it as easy as just running "Generate SQL Script" and then running the script? I know I want to script the option "Enable or create the components" but do I also want the option "Script creation of r...more >>

We have a SQL 2k (SP3a) database that we are working on setting up replication on. Our replication is Merge replication, and we are using a Push subscription. I just noticed this morning that tables on the Publisher which are defined as having the "Cascade Updates" flag set do not have the sam...more >>

Hi, I am replicating a large table from the publisher to subscriber database using basic transaction replication. The subscriber is currently an exact copy of the publisher since they were originally synchonized. (The subscriber is used as a reporting database). The subscribing database is get...more >>

At the company I work for, we have 2 applications. One which is a e-commerce based web application the uses DatabaseA and the other application is the back office processing system which uses DatabaseB. There is a common set of tables between the applications that need to be kept in sync. Ou...more >>

We're implementing log shipping and have run into problems when attempting to reverse server roles. The error occurs when we run the sp_change_secondary_role. We receive a "sqlmaint.exe" error. If the stored procedure is run 3 or 4 times it will occasionally succeed but the role reversal ...more >>

Hi, Our production database configured transactional replication with push (it is real-time database). During the day, once data loading to primary site (publisher), it took 1 minute push data to secondary site (subscriber). Is the way to reduce the latency from 1 minute to 1 second? ...more >>

Hi, Could someone tell, if I generate Snapshot and Transactional replication steps to create publication from test environment boxes (the database structures same as production site) and also generate jobs related this database from test boxes, the replication should be work on product...more >>

Hy I have one server dedicated as publisher and distributor and 82 server configured as subscriber / PULL. It take me long time to configure all this subscribers and now I am afraid what to do if this publisher and distributor server someday completely fail (hardware or software error). I ...more >>

I have 3 servers with sql2k, one as publisher and as subscripber with push merge. I bring one of the server once a week and connected to the network to make replication. (still waiting for idsn line). the push subscription is being lost or deleted from the publisher server. can i make the replica...more >>

Is it possible to replicate the contents of a view rather than a table using Merge replication? Peter ...more >>

We have transactional replication running between two SQL2K servers. Server A has the publisher dbs and Server B has the distributor and subscriber dbs I'm a fairly new DBA and my application developers are asking me if there is a way to "suspend" replication during some of our off-hours. They'd l...more >>

I have a Merge Agent that runs in continous mode and I don't have it in command parameters. I can't change it using Schedules and Reccuring. I am trying to setup every 1 hour but when I setup with this configuration the agent still working in continous mode. This means that the merge agent con...more >>

Getting this error when trying to setup log shipping. Had gotten error 14261 before this and found KB article 298743 and tried to clean up per instructions but must have missed something. Any idea what I missed?...more >>

Dear Friends I am using the merge replication for my two sites and the same is working very nice. Both the machines are connected through VPN. Sometimes my VPN connection goes down and then the replication stops. My other site adminstrator connect the VPN if the same is failed but...more >>

Hi, I would like to know if it's possible copy data from SQLServer CE (running in a Pocket PC) to SQLServer 2000 (running in a PC). I've used the Merge Replication SQLServer and I've only got copy data from SQLServer 2000 to SQLServer CE. Thanks in advance,...more >>

I am trying to connect two SQL servers in different non-trusted domains. SQLServer11 in Domain A and SQLServer22 in domain B. This is through a VPN connection. Domain A has the VPN server. On SQLServer22 I could ping SQLServer11.mydomain.local at IP address 192.168.100.50. On SQLServer22 I use...more >>

Hi all, need urgent help with the bug with sp_MSget_repl_commands that was introduced in SP3. I understand that there is a hotfix available but I cannot find it anywhere, appreciate if someone can give me direction. Another prob is that I was using Synchronization manager (in Win2K) to...more >>

I have a client server that replicates to a master server and after installing mdac 2.8 started getting the following error. Failed to enumerate changes... 3628 - A floating point exception occured in the user process. I am able to recreate the subscription and replicate the first time, bu...more >>

I am currenty designing a program to automate database replication for SQL Server 2000. I had been considering using stored procs when a colleague metioned SQL DMO to me. The program will be written as a DLL in VB 6.0. Which solution is the better way in regards to efficiency? performance? an...more >>

I am currenty designing a program to automate database replication for SQL Server 2000. I had been considering using stored procs when a colleague metioned SQL DMO to me. The program will be written as a DLL in VB 6.0. Which solution is the better way in regards to efficiency? performance? an...more >>

After setting up replication, then scripting out the replication using generate sql scripts.. When I later try and use those scripts to rebuild replication I get the following error: Server: Msg 14294, Level 16, State 1 procedure sp_verify_job_identifiers, Line 24 Supply either @job_id ...more >>

Dear friends I am using merge replication between two sites and i want to know how much updates and insert is done by publisher and subscriber by datewise. Your helping hand will allow me to solve the problem. Best regards Sharad...more >>

Hi I made an Visual Basic application using SQLDMO to administrate merge replication between two computers. Everything is working fine (create publication, push subscription, etc...) except my uninstall routine. On the Publisher side all replication objects were successfully removed but on the subs...more >>

I know we can replicate via HTTP w/ mobile devices . . . can I replicate with any SQL Server or MSDE installation via HTTP regardless of if the device is mobile? Is this a new feature in Yukon? What's the reasoning this isn't available if its available for SQLCE? Thanks!...more >>

Hello, I got a error message after I follow the create new publication wizard, the message said: SQL server Enterprise Manager can't create publication 'pub' from database db Error 515: can't insert the value null into column 'Step_name', table 'msdb.dbo.sysjobsteps', column doesn't allow n...more >>

I have set up a transactional replication between 2 sql2K-servers which are in a different domain The single subscriber is also the distributor because the publisher cannot have a performance drop, so I make the subscriber also the distributor to put as much of the load as possible on the subscribe...more >>

I use sp_repladdcolumn and sp_repldropcolumn to handle adding/dropping the columns in the publication. However, I find nothing to allow me to modify the property of the columns involved in the publication, such as changes in datatype, the length etc.... What are the steps to handle column pro...more >>

Microsoft SQL Server Log Reader Agent 8.00.760 Copyright (c) 2000 Microsoft Corporation The log reader agent gives this error, although the status says succeeded in enterprise manager and no data is being replicated. The publisher is SQL7 and the Distributor and Subscriber are SQL2000 T...more >>

I have on OLTP Database that gathers thousands of records each hour, after the record is processed there is no current need for the data, I would like to place this data into a data warehouse (for statistical purposes), my thought was to replicate the data to another database (the warehouse) using t...more >>

In the office network domain I've already setup replication between two SQL Servers( SQL11Server & SQL22Server). Now I am extending replication with SQL servers in other non-trusted domains/workgroups (SQL33Server & SQL44Server). SQL33Server & SQL44Server are in non-trusted domains connecting to ...more >>

I can not delete a server from the remote servers list even after I executed sp_removedbreplication 'database- name' at the publisher and subscriber. How do you get rid the publications and subscriptions cleanly and remove the server name from the remote server list? TIA, Lito...more >>

Some of my user are having hard time to synchronize since a while. My guess is that the trouble started when I generated a bunch of new data in one table (20,000 Records per user who synchronize). I tried reinitializing the synchronization and redo a snapshot but some users are still receiving ...more >>

Hello, I try to do replication for our databases(not snapshot), but it looks only work for those databases have only dbo schema. Can somebody tell me the reason? Thanks a lot... Harry...more >>

I HAVE ONE PUBLISHER.ONE PUBLICATION HAS A PROBLEM.THE SNAPSHOT STATUS IS SUCCEDED("A SNAPSHOT OF 6 ARTICLE(S)WAS GENERATED").THEN WHEN THE AGENT STARTS TO PULL THE SNAPSHOT TO THE OTHER SERVER IN LAST ACTION COLUMN I FIND THE MESSAGE("THE PROCCESS COULD NOT BULK COPY INTO TABLE "NEWS1"")....more >>

i have a SQL DB that needs to have replication setup for a site via VPN and for a mobile laptop PC. i have read there may be a size limitation on rows in merge replication. my DB has MS Word documents that are pretty large in one field. Is there a size limitation on the rows? Which form of ...more >>

I've set up replication between two SQL Servers and it's working fine. Now customer wants to add a server where the LAN doesn't extend. Both servers have a modem and I've configured the dialup networking so that I can manually perform the connection. The connection closes after being idle for ...more >>

I have run both sp_repldropcolumn and sp_repladdcolumn on a SQL Server 2000 SP3 enterprise database that is replicated to another SQL Server 2000 SP3 standard database. The column was dropped\ added in the database, however, the changed was not replicated to the subscriber database. The Agent ...more >>

Hi, Our production database contains tables' owner that not belong to dbo. Tables' owner belongs to 4 different user names in a database. Can this database replicate to secondary site use method transactional replication? If it can, how can I do? Thanks, Jenny ...more >>

I am currently designing a new SQL2000 Database. The design must use Merge Replication. Merge Replication, will require a column marked as rowguid for each table. I have 6 tables which will be replicated, each have a primary index (int). Should I replicate the tables as they are, and allow M...more >>

Doe anybody here have an idea regarding subscriber upgrade to publisher without re publish and re push. -Pheckz...more >>