I have just created a snapshot manually and started the synch manualy and I am getting : error 4819 - Could not bulk insert. Bulk data stream was incorrectly specified as sorted. Anyone point me to why this might be happening? Its a severity 16, so user caused and supposedly user fixable. ...more >>

Is there a way to shrink the translog at the pub if the subscriber is down for an indefinite amount of time? Without deleting the package and setting it back up again? thx -comb...more >>

Hi, Is it possible to remove/change a constraint on a table that has been published, without reinitilising the subscriber? Setup: Merge Replication Subscribers initiate a pull subscription Kind Regards Warren Patterson ...more >>

Hi, I'm new to MSSQL replication, and was hoping for some advice as to recommended practices for my scenario. I will have a 4 SQL server scenario at four locations connected through a TCP/IP wan (i.e. each site is connected to the internet). One of the sites is the headquarters site. S...more >>

Is it possible to have a push subscription for merge replication over the Internet? If so, how? If not, does anybody know why not?...more >>

My setup is Merge Replication with Push subscriptions. When a subscription expires it is deleted by the Expired Subscription Clean Up Agent. What is the best way to recreate and initialize the subscription to ensure that I get ALL the meta data changes that were made at the subscriber? I was...more >>

Hello, I am using SQL Server 2000 and have a question about the log reader. I have read, that you can schedule the log reader to run, for instance once a day. My question is when does the log reader 'know' when to stop? Thanks in advance, Duncan. ...more >>

Hi I am not able to implement even odd series, the tables are generating autonumbers with 'last value + 2' for the next value (inspite of saying identity seed is 2 and increment is 2). thisway, if the last value on a 'supposed' even table is turming odd if the last merged value is odd. is...more >>

Hi I've just installed Sql Server 7 and wanted to see how replication works. With DTS i copied Northwind database so now i have two db Northwind and Northwind_copy on my server. Using wizards (default values) I've tried snapshot replication from Northwind (publication) to Northwind_copy (pull...more >>

Hi, I have the following scenario, and need to configure replication for this. Pls advice. We have 3 SQL server databases, at 3 locations on SQL server 2000 servers. They are connected over WAN by 2 MBPS link (triangle). I have to configure replication on this. Database has around 200 ta...more >>

Long description for short question: I currently have a database application using Access 2003 as the front end and as the back end. I will be changing the back end to SQL Server 2000. The front end links to 2 databases at any time. One of the databases is the "collection" and the other dat...more >>

Hi, I am trying for the best and fastest method to do database backup restores between 64bit version of SQL Server and 32-bit. We are using SQLLITESPEED software but it gives software version issues while I am trying to restore backup in SLS format taken on 64 bit and trying to restore it on a 32...more >>

Hi everybody, we are designing an application for ships, and I want to replicate data between the ships and a home office. TCP/IP communication is not possible, but we have a e-mail based system for transferring files. What is the best solution? Is it possible to have the publisher/subscriber to ...more >>

I've looked at the avgprice example for northwind but don't understand what would happen if the conflict occured because of a delete. I'd like to create a resolver that the subscriber always wins the update unless the row was deleted at the publisher. TIA ...more >>

http://vyaskn.tripod.com/moving_sql_server.h tm I can see how it would work for just a sql server, but a sql server doing replication it might be harder to accomplish. Has anyone here done this with a replication box? TIA, -comb...more >>

Does anyone know how to manually set a Subscription to be Expired? I'm not looking for a hack, but if that is all you have I will try it. I was hoping that there might be a system stored procedure that would do it, although I know that is pretty doubtful. The reason for this is because now I h...more >>

Hi I am trying to setup transactional replication. when i run the script it runs fine. but the snapshot agent is not running. i can see that in distribution..MSSnapshot_Agents table. but when i try to run that in enterprise manager its giving me error message that specified job not fou...more >>

Hi, The snapshot agent is failing with the following message. The MDAC version that i can see is 2.71.XXXX. Rightnow, i am having all the publisher/distributor/subscriber on the same server. Can somebody help? Error: The process could not bulk copy out of table '[XXXX]. [XXXXXXXXXXX]'. ...more >>

I am setting up a pull subscription and I keep getting an error message: "SQL Server Enterprise Manger could not create a pull subscription to publication 'XX'. Error 14053: Cannot load the DLL replincrementlsn extended procedure, or one of the DLLs it references. ...." Any suggestions on...more >>

Hello, I have to setup custom conflict resolution so that the most recent update wins using a column 'lasteditdate' in a a merge replication scenario and have about 150 tables to do this on. Do I have to configure each table/article individually or can I do all necessary tables in one sh...more >>

Is there a fix for the SQL transactional replication where you can only have 255 columns in a table? The error message I'm getting is: Error 20068: The article cannot be created on table <table name> because it has more than 255 columns. What are the fixes for this? Thanks! --- Po...more >>

Good morning, I am attempting to set up merge replication between a SQL Server on SBS2003 box (publisher and distributor) and a SQL Server 2000 box (subscriber) in a different state (hosted, connect via IP addresses). I can push the publication to the subscriber, but the synch process fails ...more >>

Syntax sp_repladdcolumn [ @source_object = ] 'source_object' , [ @column = ] 'column' ] [ , [ @typetext = ] 'typetext' ] [ , [ @publication_to_add = ] 'publication_to_add' ] [ , [ @schema_change_script = ] 'schema_change_script' ] [ , [ @force_invalidate_snapshot = ] force_...more >>

I use merge replication between parent company and subsidiary company.parent company is central subscriber. I only want to merge when publisher insert and update data or subscriber update data. I don't want to merge when publisher delete data or subscriber insert and delete data. who can giv...more >>

Hi, While running distribution agent i faced error message "The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated." If we reinitialize the subscrition is it will start the replication from scratch ?? If does so can ...more >>

Everything is working great except ONE table is not replicating INSERTS from the subscriber back to the publisher. UPDATES *are* being replicating, and INSERTS *are* being replicated for every other table! I can't figure out what's going on. When I first setup the subscription/publication, t...more >>

Hopefully, someone can provide some advice regarding filtering data by dates. We have data that we want to expire from the sqlce database because it has reached a certain age. Filters have been applied to only replicate data wihtin the date boundaries we require. What we have found through tes...more >>

Syntax sp_repladdcolumn [ @source_object = ] 'source_object' , [ @column = ] 'column' ] [ , [ @typetext = ] 'typetext' ] [ , [ @publication_to_add = ] 'publication_to_add' ] [ , [ @schema_change_script = ] 'schema_change_script' ] [ , [ @force_invalidate_snapshot = ] force_...more >>

Hi, i have setup the database schema with partitioned identities to even and odd. I have successfully configured the distributor through EM. Now when i am trying to use the enterprise mgr, to configure the publisher, i am getting an issue of the wizard adding a new rowguid column in the Article iss...more >>

On a test database I issued this: sp_repladdcolumn @source_object='auction' , @column='MyNewTestCol' , @typetext="char(1) NOT NULL DEFAULT 'N'" the error I got back was this: Server: Msg 14027, Level 16, State 1, Procedure sp_repladdcolumn, Line 90 auction does not exist in the current d...more >>

I posted this to sqlserver.tools. Should have posted it here instead. My apoligies. Is there any tool, commercial, freeware, by MS or something thats easy to build that does synchronization of a SQL server database with an MA Access database? Now the schemas of both these databases are the ...more >>

We are planning multiple remote sites, each running 5 XP Pro or XP Embedded which will logon to a Windows Server 2003 machine at Head Office via a WAN. Each XP machine in the site will be replicating its single db to the 4 others via Merge Replication. We will also be using MSMQ 3 for communica...more >>

Hi, we want to remove all subscriptions on our SQL server. We deleted all distributions on the distributor, but some of the subscriptions on the subscribor are not deleted. What did go wrong? Is there a way to delete them hardcore on the subscribor? Thanks in advance Jochen ...more >>

Hi, I have a couple of questions which I am hoping someone could answer. 1. I am working on Merge Replication between SQL server 2000 and MSDE. I am trying to replicate a test publication with just one row. A push seems to be working, but when I try to pull a subscription, nothing happens. Th...more >>

Hi Guys, I implemented log shipping but if database is open during load the restore is failing. i think i selected "terminate users in database" option. how i can confirm whether i selected this option? and if not how can i change this. THNKS BIJU ...more >>

**PLEASE help. Restore of Log Shippng is failing** Job error is: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. Detailed output of the job says: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backu...more >>

Hello all - We have a published db which we backup daily. In order to restore the database, we run a scripts which removes all subscribers, restore the db, and then run another script to add all subscribers. We then have to re-init all. ( The remove / create scripts are generated by EM ). ...more >>

Hi, I want to replicate my data with a sql server in internet(via dial-up connection). Do I necessarily need to use FTP for transferring the initial snapshots or it is an alternate solution? I saw this in article number '321822' in Microsoft's site, the second example in this article mentions:...more >>

hi, for maintainance tasks (converting database from SQL_Latin to Latin_General) we scripted a working merge replication and removed it with Enterprise Manager (3 servers, 1 database, SQL 2000 SP3 on all 3 Servers). Now, when trying to reinstall the replication (via script or EM), the pub...more >>

I want to use transaction replication technology to deal with the data about parent company and subsidiary company. but my trouble is: does subscribers have the data which subscribe from publisher when I had delete the data on publishers. I only want to subscribe the data which be insert or upda...more >>

Hi all, I need all merge replication history created (full and complete since the first time) to be filed. How and where can I get this? TIA echo...more >>

Hi, I have two databases which have previously been replicating via merge replication. I have removed replacation from one of the databases (the smaller) one, and noticed during this process the system slowed to an absolute crawl. My problem is, i need to do the second (and much larger data...more >>

I have an application using SQL Server 2000 and Delphi for the front end. I have 2 SQL Server, on each side of a WAN and 15 offline users with Laptops that sync using Merge replication. This app has been running successfully for about 6 months now. Lately, I am getting a few conflicts fr...more >>

Hi, is it possible to move the distributor from one SQL2000 Server to another, without deleting existing publications/subscribers?...more >>

Hi, I am using snapshot replication and want to create pull / push replication but I always encountered same problem : Login failed for user . . . I think I had already set my user as an Administrator but it didn't work. Thanks in advance ! Michael Rawi...more >>

I have maybe 10 tables in a database that is being replicated that are = owned by an owner other than dbo. Oddly enough, I am seeing a newly created table in my Subscriber. For instance, I was looking at a table; = adage.adage_user.reprint_shipping_tbl_usr=20 on the Subscriber. The data w...more >>

I posted this yesterday but in reply to an earlier post and thought that perhaps it was overlooked. Error: The row was not found at the Subscriber when applying the replicated command. (Source: AFNBLDRPT1 (Data source); Error number: 20598) Both the publisher and subscriber are on sp3. The...more >>

Hi, I am developing software in a distributed development environment. Each individual developer wanting their own copy of the database to play with and I would like to be able to bring all their changes back to a common database. I have had a little play with a pushed merge replication and...more >>

My subscriber database transaction log continually fills when the = Distribution Agent is running, attempting to bulk copy the schema & = tables of a new push subscription. Subscriber database is set to simple, so why is the transaction log = filling & not truncating? What did I fail to set p...more >>

How can I get an idea of how long it takes for a transaction after it is made in my table I am publishing before it hits the subscriber? TIA Miriam...more >>