Is there a way to convert/copy a DB created within SQL Server 2000 Standard edition to SQL Server 2000 Desktop Engine? This needs to be done to connect the database to Visual Basic.Net which doesn't support connections to the standard edition of SQL....more >>

I have some publications with many subscriptions as part of transactional replication. Why cant i see all those distribution agents in the perfmon counters for SQL Server: Replication Dist object under instances ? I see just 2 out of the 20 or more that we have . I am using SQL server 2000 ...more >>

sql2k sp3 I have replication successfully working on a number of tables. Someone tried to insert a null value where they shouldnt have. I get the message: Cannot insert the value NULL into column 'cr_username', table 'adv084dk2.dbo.current_run_cr'; column does not allow nulls. INSERT fails. (...more >>

I have setup a Transactional replication (two SQL 2K, SP3 running Win2K). When I try to run the distribution agent, i get this error: Error Message : Line 29: Incorrect syntax near 'UPDATE STATISTICS '. Error Details : Line 29: Incorrect syntax near 'UPDATE STATISTICS '. (Source: IP Addres...more >>

My distribution agent is running really slow, and I can't figure out why. I have the publisher and the distributor on the same server, and I am only subscribing to one other server. My log reader is putting about 904 cmds/sec into the distribution database, while the distribution agent is ...more >>

I'm getting this message "The initial snapshot for publication 'mydb' is not yet available" from the distribution agent. What does this mean....more >>

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 >>

What are the implications of having a SQL Server 2000 instance named "database"? It's the only instance on the server, but must replicate (publish & distribute) data to remote servers (subscribers) that may be default instance names or named instances. Thanks for any input, Tom ...more >>

Hi when i execute sp_addmergepullsubscription, i get the following error. Warning: The table 'MSsubscription_properties' has been created but its maximum row size (8361) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting ...more >>

I'm getting the following output from one of my subscribers. The really odd thing is that I pushed this publication to another subscriber yesterday and it went through correctly with no problems. Any ideas? I've already removed the subscription and re-pushed it to the subscriber. Should I ju...more >>

I am getting this message when running the snapshot agent: Last Action: "The process could not bulk copy out of table '[dbo].[syncobj_0x3230414139344244]'." Error Descr: "ODBCBCP/Driver version mismatch" Both servers are running SQL V7, sP3 and MDAC v2.6RTM Any suggestions? Regards,...more >>

Hi We are using Dynamic Merge Replication and we seem to have a problem with the intial snapshot. When trying to apply the snapshot, the process expects the published tables to exist on the subscriber. I thought it should simply create them if they don't exist? Also I have tried to create ...more >>

Hello ! I=B4ve now successfully set up a merge-replication between=20 different SQL Server2K. Now, I want to start the=20 replication on users demand from inside an application.=20 What do I have to do ? Must I create a job and then start=20 this job ?=20 Thanx=20 Morgie...more >>

The distribution agent seems to have failed with the following error message Last command{call sp_MSget_repl_commands(46, ?, 0, 7500000)} Error Message Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__053E7DEC'. Cannot insert duplicate key in object '#044A59B3'. Error details Vi...more >>

Help, My dist and Pub DB is on DB1, and subscriber on DB2. On my publication database, once the Log reader initializes, I get an error: category: ODBC source: ODBC SQL Server driver Number: 0 Full message: Timeout expired any ideas would highly really appreciated... Thanks!! ...more >>

Can I control the order of tables in data loading of snapshot creation? I need the data loading will start with foreign key tables and finish with primary key table, so the foreign key tables will not contain new records that their key not exist in the primary key table. Any help is appr...more >>

I have a SQL7 server that is the publisher. Two SQL 2000 servers have pull subscriptions defined. One is a clustered server, the other is not. If I reboot the SQL7 server, the non-clustered server re-establishes connections and everything is fine. The clustered server always shows as "Agent ...more >>

I have a pull subscription set but every morning when I check on it I have the status "Agent is suspect. No response within the last 10 minutes". This should not really be a problem if the replications was still running but it is not. I have to start the pull subscription again manually. Isn't...more >>

My replication publication fails on a table, because it has more than 255 columns. It there a limit I'm crossing somewhere? Thanks for any help -Travis ...more >>

Hello all, The replication contains several large tables related by foreign keys. Data continue to be inserted during the snapshot creation, which leads to foreign key failure while the snapshot is applied to the Subscriber. Before I manipulate the choice of records using filters, is the...more >>

I just disabled replication on my server. The conflict tables are still in my DB though. Is there a way to get rid of them? My Access front end chokes on the amount of tables it links to. Thanks, Joe...more >>