Hi, There is an argument "schema_change_script" in sp_repladdcolumn. I didn't find how it works in SQL BOL. Can someone explain it to me a bit more? Thanks Darius ...more >>

I have been trying to setup a merge publication and I keep on haveing Convergence Errors when I test. I have found a document explaining the non-documented ForceConvergenceLevel Merge Agent Parameter which seems like it would correct my problem. However, when I try to adding the ForceConverge...more >>

Hi, We're using transactional replication from SQL 2000 sp3 to a subscriber, a SQL 2000 sp2 server. The subscriber is also the distributor from where the snapshot agent runs. The publication does not allow annonymous subscribers. We're using a push subscription. We use verticle filt...more >>

I am new to replication and I would appreciate knowing if replication can handle this business problem before setting up test systems to work out the details. We have one customer sales application in many offices worldwide. The application manages customer registrations into the seminars our ...more >>

Hello! I'm trying to make Merge Replication to ODBC subscriber (PostgreSQL 7.3.4). I could use some help for that, if some one has some experience in that field. I did succeeded to create one subscription but it gives me the following error: An invalid parameter or value was specified in...more >>

Hello: I'm working with Sql Server 2000 and Windows 2000. I have a problem with merge sincronization over internet, I get an error saying that is not posible access to the distributor because is not possible find the server or access denied. In the suscriptor computer I'm using a small Vi...more >>

I have a SQL Server 2000 DB as my publisher/distributor and a SQL CE DB running on a pocket pc device as my subscriber. I have managed to get all the tables to replicate onto the device just fine but now my problem lies in trying to apply filters to my row data. For Example: I have an Employ...more >>

After using the Create Publication wizard to set up a publication. When the Finish button is clicked, the following error message is received: "SQL Server Enterprise Manager could not creat publication 'Name' From database 'database name'. Error 14294: Suppy either @job_id or @job_name t...more >>

I'm having a problem with merge replication that hopefully someone out there can help with. The problem is following : The process could not deliver update(s) at the 'Publisher'. (Source: Merge Replication Provider (Agent); Error number: -2147200989) -----------------------------------------...more >>

Hi expects, Currently I am using Merge publication. I would like to be enable changes made to the stored procedures in the publication database be replicated down to the subscriber database. I tried to drop the published stored procedures so I can create the updated stored...more >>

I'm trying to create a publication using the sp_addpublication stored procedure without much success. I've used it previously to create other publications but for some reason on this particular database it keeps failing. The syntax I have used is :- use master GO exec sp_replicationdboptio...more >>

I have two servers running sql server2000. Server1 is a publisher/distributor and server2 is a subscriber. I configured a merge replication with pull subscription. When i configure the replication and filters, all was find but when i try to send the first snapshot to the subscriber it re...more >>

Hello, I have an issue which is driving me nuts. The issue is with transactional replication with immediate updates. I have two sql servers (Server A and Server B). Server A is the publisher and distributor and I have set up a trans. replication with immediate updates to Server B. T...more >>

Hi, I have SQL Server 7.0 with SP4. I get these two errors from the logreader 1. "The process could not execute 'sp_repldone/sp_replcounters' on 'servername'" 2.The process could not execute 'sp_replcmds' on 'servername' Can you please guide me to overcome from these errors. Thanks....more >>

I created a transactional replication in SQL2000. I decided not to create a snapshot of the schema and data because the database in very big and it is already in the subscriber. I restored a backup of the db in the subscriber. After creating the publication and then the subscription wi...more >>

Im having an error of: The row was not found at the Subscriber when applying the replicated command. I noticed that a user was pegging the server by creating linked tables in access. He is now deniged access and I have set the option on the agent: Continue on error. DO I have to totally re-...more >>

Hi, I used Enterprise Manager to set up replication between two SQL 2000 Servers. When I did this, a "Remote Server" was created on the Publisher (which is also the Distributor). Now I need to create a "Linked Server" on the publisher that references the subscriber. When I tried to create t...more >>

I am trying to setup Merge Replication. When I run the Configuring publishing and Distribution Wizard in Sql Server 2000 Enterprise Manager I get this. SQL Server Agent on 'Server' currently uses the System account, whcich causes replication between servers to fail. In the following dialo...more >>

Hi all I have a situation where I would like to stop replication to one subscriber whilst the publisher does some fairly complex work. I am using merge pull replication from a SQL Server publisher with many MSDE subscribers. There is only one publisher article as the subscribers filter data by...more >>

I'm try to move SQL and applications to a new server on the same domain.. Only login that uses SQL is the SA login from the application. Do I need to be concerned with SA not working if the SID is different?...more >>

I am attempting to set up log shipping, but I am having some problems. It will not restore the logs tp the remote database. I get the following error. --This error is on the destination server for the restore job. Executed as user: Domain\Norm. sqlmaint.exe failed. [SQLSTATE 42000] (Erro...more >>

We've got 4 log reader agents running on one distributor and one of them fails frequently. The error is on the step 'Detect nonlogged agent shutdown'. In other words it detected a shutdown but with no explanation. The error is 'the step did not generate any output. The step failed'. ...more >>

Hi, i have two servers with sql servero2000 sp3. Server1=20 is a publisher/distributor and server2 is subscriber. When i configured the replication it was fine even the=20 syncronization didn=B4t report problems. Today I get this error:=20 {CALL sp_MSupd_tablex (NULL,NULL,NULL,74,NULL,NULL...more >>

hi all i moved to win2003 and installed sql 2000 +sp. Database looks fine - but i can not create any trans replication that works. their is error notification from the log reader about access violation - i cpmared the configuration of the win2000 server and the win2003 and it looks the sam...more >>

I have a customers table that each night is updated from an external source, ala: UPDATE MyServer.dbo.Customers SET Address = TheirTable.Address FROM TheirServer.dbo.Customers as TheirTable WHERE TheirTable.CustomerID = Customers.CustomerID (This is a simplifeid version, it actua...more >>

I've got a SQL Server 2000 database on a remote server, at an internet hosting company. I can connect with it using TCP/IP and Enterprise Manager. It's a simple database, no transactions, or for that matter much activity at all. I want to copy the whole thing, i.e. tables and stored procedur...more >>

I'm using transactional replication and I have replicated a table that has about 1mil records and grows by about 2 records a minute. New transactions are getting in but its hopelessly behind by about 7000 records. It there anything I can do to speed this up? ...more >>

Looking at a machine with Pull Subscriptions used in Merge Replication, the following error is produced. Number:0 Message: Stored function 'sp_MSgetversion' in the library 'xpstar.dll' generated an access violation. SQL Server is terminating process 54. Any ideas what this is about a...more >>

Hi all: Anybody knows where can I find 'syspublications' table, (It's used for stored procedure 'sp_msdrop_expired_subscription') Any suggestion will be appreciated,thank you! ...more >>

Hi al.. We're working on a SQL2000 .Net project with the following requirements, and are trying to decide whether to roll our own or use Merge or Transactional replication. Any recommendations appreciated. Client runs a multi-branch mission critical system with around 200 users (say 40 con...more >>