I know an add and drop column can be achived using sp_repladdcolumn and sp_repldropcolumn. Whats the easiest way to take care of an alter column ? ...more >>

Hi, Does the first synchronization(Replication Agent) while setting up merge replication locks both the publisher and subscriber databases or the databases can be used while the first synchronization is taking place? If first synchronization does not lock the databases, will the changes that...more >>

I have setup a replication sandbox with the following: server: SQL-Server 2k workstation: MSDE 2000 (A) I have setup a replication database on my server and configured it for anonymous pull subscriptions. I am running this inside my LAN. I run the following code in an Access 2000 modu...more >>

when trying to merge data of type text I get this error message and the change gets rolled back. Can somebody point me in a direction to solve this. THank you in advance. Pauly C...more >>

When transactional replication fires an insert trigger on the subscriber server/database/table, does the trigger run under the same spid as the replication process that fires it? Strange question, I know, but I have to modify an insert trigger to fire only if the table has a row inserted from...more >>

I am set up a Windows 2003 server with SQL Server 2000 replication. What are the set of performance monitor counters (perfmon) that should be added to my present counters to be able to analysis replication performance? Thanks, ...more >>

I have to implement a simple Merge-Replication, using the MSDE. That means, I can´t using Enterprice-Manager. I don´t want using SQLDMO because of redistribution-problems. Using T-SQL, it is quite difficult to implement Merge-Replication. Are the thrid-pary-products, ActiveX-Controls, Libr...more >>

I am working on Microsoft Navision Axapta and MS-SQL Server2000 I had made a view and inserted the records in Axapta table. But every time have have to exeute the script and it is not good in performance. I want to write a job for the script that when the server is not busy it should execute ...more >>

Hilary, I know you have helped me with a replication latency script in the past. But what i want is more of the following . I have trans replication set up in continuous mode. If I stop the log reader agent and the distribution agent while my publisher is receiving some changes, I want to...more >>

I have to set up replication on SQL 2000 server. There is only 1 SQL server. I have read some info and have done replication in Access, but I'm not sure about having separate subscriber on same server. We will have about 6 laptops running MSDE doing infrequent (weekly?) synchs with master ...more >>

Hi, I built a database replication between 2 SQL 2000 servers in our domain (both with SP3). I used snapshot publication and it worked for a few days. But one day the Distribution Agent task failed with the following, Error message: Line 95: Incorrect syntax near 'DROP TABLE '. Error ...more >>

Hello Guys i have a big problem between my company's two branches the problem in brief is we have two sites in two cities and of course two SQL servers in the two sites so we have a dbase application but when we try to get the updated records from one site to another we got this error messege ...more >>

Ive got trans repl set up. Is there a single stored proc that can just drop it all or clean up any remnants of any replication that may be still around.. Thanks ...more >>

1 Way trans. replication to a mysql database SQL Server Env: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Windows NT 5.0 (Build 2195: Service Pack 4) Distribution Agent: Error Details: Invalid cursor state (Source: ODBC Driver Manager (ODBC); Error number: 24000) ------------------...more >>

I've been running SQLServer 2000 for years but now I need two servers to have load balance and high availabilty, but WITHOUT using a cluster. Could some point to some pages/tutorials for start investigating? Thanks! ...more >>

Hi NG, I try to understand the internals of mssql2k-Replication. In my testsystem I found any rows in msrepl_transactions without reference (via xact_seqno) to msrepl_commands. sp_MSget_repl_commands shows nothing with the xact_id. Whats this for transactions? Regards Thomas ...more >>

How many distribution databases can we have ? ... Say I have one publisher /Published DB and multiple subscribers. Can I have as many distribution dbs as the no. of subscribing dbs or just one per published db or just one per publisher ? Can someone get my basics straight ? ...more >>

OK please forgive me. I dont normally cross post, or ask the same question twice, but Im in quite a pickle here. Ive been using replication in a non clustered environment for years now. Ive never seen extreme slowness with the initial snapshot of replication like Im seeing currently. And to to...more >>

I am starting replication and experiencing a very slow snapshot. Ive never measured before how fast they are really generated, but I've never seen them this slow. Both the Publisher and Subscriber have: Two 3 gig processors. 4 gigs of ram. 1 way Transaction. Remote Distributor. (On the Su...more >>

Hi All: I have set up Merge Replication over VPN. My problem is that my Database to be replicated is 2.5 GB. Should I upload the Database, before setting up Replication by way of FTP? Or the snapshot will take care of it? If I upload the Database via FTP & attach it & then setup replication,...more >>

Hi, I have to update regularly (twice a day) an SQLServer 2000 DB on a remote location, what has only a 128 k line for Internet (even that in not working always). The source DB is on SQLSeerver 2k too. Only some tables from the given DB are important, but I can not make any structural chang...more >>

Hello I'm going to create replication between more then 10 SQL Servers. Now it is running in my office ( i have 100Mbps network )and it works fine but it will have to work with about 512kbps :( It is a merge replication. My merge replication agent is set to 1000 download/upload querys per batch ...more >>

Hi NG, I use with backup', 'true' on Distribution and PublisherDB. If I make a RESTORE on the SAME SERVER, is it necessary to set KEEP_REPLICATION? BOL says, that KEEP_REPLICATION only must be set if the restore goes to another server. And why should handling the LOG? Thanks Thomas...more >>

Hi, Replication to a MS-access database fails last week. It has always been working, but now I get this message: DISTRIBUTION AGENT ERROR Error : The process could not connect to Subscriber 'MAB-EC-NW'. Error information: Microsoft JET Database Engine (number = -534709256)...more >>

I have 2 questions regarding MSDE to SQL-Server merge replication 1) Do I have to setup a anonymous pull subscription within the SQL-Server Pub/Distrib before I can run a synch from an MSDE subscriber? I plan on using the VB sqlMerge contol to create the initial snapshot and subsequent mer...more >>

Category:NULL Source: Proveedor de duplicación de mezcla Number: -2147200999 Message: El proceso no pudo enumerar las modificaciones en 'Subscriber'. Category:COMMAND Source: Error en el comando Number: 0 Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)} Category:SQLSERVER Source: ...more >>

Hi all... I am trying to copy all tables, views, and stored procedures (except for only one table the user does not want copied) from a database on a remote server to another database on a local server. Every time I try to run this copy procedure, it runs for a while and the throws the foll...more >>

Hello, We have 3 SQL servers in 3 different cities Sydney, Melbourne and Perth. Which are replicate with each other over 128 Kbps lines. Our database is about 100 GB. Is there any way i can add a new table to the database without having to re-publish all the data? The new table also has t...more >>

Hi All: We have to set up Merge Replication in our center over VPN. The problem is nobody inhouse knows how to set up replication & resolve conflicts, if any. We want to recruit someone specialist on replication. Now I need suggestions for the questions which need to be asked to candidates. ...more >>

Hi All: We have to set up Merge Replication in our center over VPN. The problem is nobody inhouse knows how to set up replication & resolve conflicts, if any. We want to recruit someone specialist on replication. Now I need suggestions for the questions which need to be asked to candidates. ...more >>

I have a database (SQL Server 2000 Enterprise Ed.) with a single table (Products), which has 3 columns set for Full-Text-Indexing. This database is working fine. All queries are done through Stored Procs, and works like a charm. I tried to copy the database to another database (SQL Server 20...more >>

In an Access 2002 (Runtime) Project (.ade) (on a Windows XP Pro Laptop) connected to a merge anonymous subscription (hosted on the <local> MSDERelA): I would like to put the Synchronize Now functionality INSIDE the Project. Currently we use the Windows Synchronization Manager (Start, All Pro...more >>

Hello, I currently have a database set up for replication on 3 servers as follows: Pub - users connect and update database Sub1 - database is accessed for local application Sub2 - database is accessed for local application The subscriptions are set up for both immediate and queued u...more >>

Hi, we want to use the msde version of sql server 2000, but we need to use transactional replication. Do you know if it is posible to configure transactional publication with push subscription on a msde version?? This is the scenario I need: msde server: standard edition trans...more >>

Scenario is (Totally separate physical servers) ServerA - Publisher ServerB - Distributor ServerC - Subscriber (Pull) When I do a snapshot where does the BCP process actually run? I ask because ServerB is a 2-way and ServersA & C are 4-ways. I don't want to saturate a 2-way with -MaxBCPThre...more >>

Help; I am setting up SQL 2000 Enterprise Edition SP3, using The MS Navision Client 3.70a as the end user client software. my corp office is in CA and I have a remote site in PA. I need the CA and PA servers to replicated the Navision SQL Database. I can get replication to succeed but ...more >>

Found Paul Ibison's article @ http://www.sqlservercentral.com/columnists/pibison/alteringacolumnonareplicatedtable.asp I'm trying to simply change the size of my ItemNumber column in table RequisitionDetail using this code: exec sp_repladdcolumn @source_object = 'RequisitionDetail' , @colum...more >>

Hi all, I have a problem with data rows in a header table vanishing without a trace. The header record has related detail records with related FK constraints (not enforce relationship with replication) The header record also has a link to another detail table with a FK constraint (enforce rel...more >>

Hi there, we use a merge replication via vpn. Sometimes the connection is dropped for a few hours. So we had to check this manually and click the start synchronize button. We also modified the agent , so that he tries at the time of 100 minutes to retry... But my question is how can i c...more >>

CIAO all people...! Ihave 1 database di access 2000 built on 20 table...query and form, users insert record easy from form. I have Microsoft SQL Server Service Manager 7.00.623. I have the same database in web space ...ex ...(ad esempio ftp.tiscali.it/azienda/db/data.mdb) how to syncroni...more >>

upgraded a server last night to SP3 and all of my push subscriptions disappeared, but all the publications remained. When I go to recreate them, the push subscriptions, I receive the following message.... Error 2812: Could not find stored procedure 'distribution.dbo.sp_MShelp_subscriber_in...more >>

Ok, this one has me stumped. I have transactional replication working in all regards between two sites except for one table that continues to give me problems. The only difference between this table and the others is that I have a stored procedure that populates this table with images that have...more >>

SQL 2000 SP3: There is a table with more than 254 Fields in it. (please don't ask why :-) ) we observed, that replication on fields which are beyond the magic limit of 254 simply do not replicate. ( Enterprise manager says Replication takes place, but data do not show up at destination. Is ...more >>

We have found that we need to add additional indexes to tables that are involved in transactional replication. Is there a way to change indexes on replicated tables without having to break replication and re-build it? -- David...more >>

I have two clusters running SQL2K SP3. Each has multiple publications and multiple logreaders (~12). The logreader agents on 1 cluster connect to itself using named pipes while the other cluster has its own logreaders connecting to itself using tcp/ip. Does anyone know where this is config...more >>

Dear Friends I am getting the following error. The job failed. Unable to determine if the owner (DOMAIN\Administrator) of job Distribution clean up: distribution has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Administrator'. [SQLSTATE 42000...more >>

I have two transactional publications using the same source database, one for the tables and one for the stored procedures. The reason for 2 separate publications is so that I can reinitilaize the stored procedure publication when changes are made to the stored procedures. The question I h...more >>

Hello, I have a problem with merge replication. 2 days ago, one subscriber stopped replicating with error "The process could not query row metadata at the 'Subscriber'". The other two subscribers are still working fine. The network seems to work fine between the two servers. I tried to re...more >>

I would like to create the filter for some of my merge aticles so that the subscriber get a blank table because all they are going to do is add items and ony edit or delete the items they have made. I am using sqldmo and I am not sure where I set the filter up. I see the option of ..subsetfilt...more >>

Does SQL Server 2005 Express Edition support replication? How about MSDE 2000?...more >>

I upgraded a server last night to SP3 and all of my push subscriptions disappeared, but all the publications remained. When I go to recreate them, the push subscriptions, I receive the following message.... Error 2812: Could not find stored rocedure 'distribution.dbo.sp_MShelp_subscriber_info...more >>

Hi All: I am getting this error: Please "The process could not deliver the snapshot to the Subscriber" Please advise what is the resolution to this. Microsoft says on its site that this is a know bug in Win2000, has also provided a fix. Should I go & install that fix ?? Need urgent help! ...more >>

Hi, I have a merge replicate setup and is working fine. Suddenly since last 4-5 days my "Expired subscription clean up" stored procedure started failing. The error message in the job history is Unable to connect to SQL Server '(local)'. The step failed. Can somebody help me to resolve ...more >>

Hi all, I am trying to publish data making the same server as Distributor while using the wizard it says i am using "sa" account and the server cannot be used as a distributor if i use "sa" account,how do i go around this? do i need to stop the server and start with a different account? an...more >>

I have set up SQL Server transactional replication when I start the snapshot I receive the error listed below. Error: Not enough server storage is available to process this command. Please help me resolve this error. Thank You,...more >>

Hi, SQL Server 2K Enterprise Ed, running Transactional replication, four articles being replicated, 1 article containing over 15 million rows. That table has 4 indexes on it. I created a job that executes a DBCC INDEXDEFRAG statement against each of the indecies, I run the job at the weekend,...more >>

Hi, I have a problem with rows deleted at subscriber could not get deleted at publisher in particular case where article published say table1 has row filter like "SELECT <published_columns> FROM [dbo].[TABLE1] WHERE ([FILED1]='XYZ ' OR [FIELD4]= 'XYZ ') and FIELD3 in(select [FIEL...more >>

I just setup a Transational publication that contains both tables and stored procedures as articles. I added a subscriber and successfully generated the snapshot. But when I start the agent to sync the subscriber I get the error shown below, any thoughts? Procedure or function sp_MSset_subs...more >>

What does OS Error 2 mean in realtion to a file in the snapshot not being able to be read?...more >>

I wonder if anyone can help with the following error message I receive after attempting to restore a transactional immediate updating publication: Could not bulk insert. Bulk data stream was incorrectly specified as sorted. (Source: ... (Data source); Error number: 4819 ----------------------...more >>