do people really respond to all of these questions?...more >>

Hello, I've encapsulated some logic into a stored procedure that I need to have my publisher (which is also my distributor) run each time replication is done. We are using merge replication with dynamic snapshots. I have two problems that I have encountered: 1) Where do I place the code to...more >>

If I have a DB with suspect status (failed to close properly after failed back-up) is there any way I can remove the replication? At the moment it says I cannot as the DB is not accessable. I can't remove the DB because it says it is being replicated. Cheers...more >>

Hi, I have a problem with droping and recreating Merge Replication using scripts (created from the Enterprise Manager). Do I need to drop the Distributer as well using the script?. and recreate again? OR It is not required to drop the Distributer..(I have problem If I dont drop the Distributer) ...more >>

Due to a recent increase in spam sent to posters in newsgroups, Microsoft advises that newsgroup participants should consider avoiding posting to newsgroups using their real email address. Microsoft is also committed to continuing to address the issue of spam from a technological perspective. ...more >>

hi, I have two Sql servers running sql 2000 enterprise edition I am restoring a pubs database from the backup(it is of pubs database on server A) on server B and i named it pubs_restored. On another box on Server A in pubs databse I am creating a publication of transactional replication type on pu...more >>

Hi, I need to setup merge replication to a remote SQL 2000 server. The replication fails and reports "Could Not Initialize Subscriber". Below is the error listing. What do I need to do on the remote server to make this work. The remote user has dbo_owner privileges. Should I run the "Att...more >>

Hi there, I'm trying to connect to my AS400 server thru a LINKED SERVER, but = I'm having some troubles. If someone have this solution Running or has passed thru it before, = your help will be appreciated. Thank you very much. Below is the full script I'm Using to create ...more >>

When i am inserting in subscriber database which also configured as push publication to publisher, it is shwoing sa log in failed. what could be the reason. is something we should have same logins in publisher and subscriber. What is the latest service pack, i know sp3a is old. Thanks, Jay....more >>

I have 4 SQL servers in diff regions. I want to replicate between all must have same data at a time. which replication helps me and better in performance? Thanks, Jay....more >>

Does replication copy indexes or only raw data? Are snapshot and merge replication different in this regard? Thank you, terris ...more >>

I can't make my merge replication work. Please help. My setup: Win2k Advance Server with SQL2K as Publisher and distributor. Desktop PC running Win2K pro with MSDE as subscriber. I am using pull subscribtion. after I click start synchronizing, i noticed following error in the job history: ...more >>

I am using merge replication in mixed mode authentication and I am receiving this error when I try to syncronize: The schema script '\\TLCDATA1\C$\Program Files\Microsoft SQL Server\MSSQL$NetSDK\ReplData\unc\TLCDATA1 $NETSDK_TLCProjectSQL_TLCProjectSQL\20031013113004 \Instruments_1.sch' cou...more >>

Hi ALL, I am Running WIN 2000 Server and SQL 2000 SP 3 using merge push replication. I have a number of publications that range in size from a few K to 700MB My problem comes when I need to initialise the subscribers. I setup dynamically filtered publications that compress the snapshots ...more >>

Im connecting to this group using Outlook Express. (In my companies research room.) I see very current, up to date posts. However, when I log on to the MS site and connect to these groups (from my desktop) the posts are over 6 hours old. Could you guys please update? ...more >>

Hi, I m trying to create merge replication across internet, in which the publisher is my local server and subscriber is the web server where i just have the database owner rights. I m trying to deliver the initial snapshot using ftp, to the subscriber. But while creating pull subscription...more >>

Microsoft User this is the latest version of security update, the "October 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to pr...more >>

MS Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to maintain t...more >>

Hi, I need Your assistance. I've connected two Ms SQL Servers 2000 using transactional replication method. After some use distribution agent has generated such error: EXEC sp_MSins_BRO_101 '2003-10-10 00:00:00.000',N'1Z9778296643697167',N'977829GMP73',null,0,4,N'DISPLAY / FCO ...more >>

Microsoft Partner this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to help...more >>

The default calls for custom stored procedures to be applied at the subscriber for inserts,updates and delete statements in the form of sp_Msins_article,sp_MSupd_article and sp_MSdel_article.. What are the pros and cons of using SQL instead as opposed to these stored procs...i.e @ins_cmd ,@del_c...more >>

1. Is a snapshot replication process started programmatically? Or it is automatic somehow? 2. While a snapshot replication process is copying from M to S (master to slave), and queries are executed simultaneously against S, is it possible to see inconsistent query results? What happens if re...more >>

Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now t...more >>

Hello All, I would like to know if there is a detailed design document or text book about SQL Server merge replication. We move a lot of data using Merge Replication. The Merge Agent will work fine until it gets to a table with large number of changes or a large amount of data (images, text). The...more >>

Is there a way to disable parallelism for all the distribution agents participating in trans replication using SQL 2K ...more >>

I am trying to set up what I guess will be a relatively simple pull replication. I am trying to get an MSDE to pull a merge replication from a SQL Server and in turn, I want a SQL Server CE to pull data from the MSDE. I have set up the Distributor and Publisher but whenever I try to subscribe ...more >>

What does sp_MSadd_repl_commands27hp do ? ...more >>

I noticed some connections being blocked by iself in addition to another spid Heres what is noticed in sp_who2 spid blkby 100 100 100 100 100 100 100 90 120 120 120 120 120 120 120 90 Noticed some waittypes of CXPacket for some and LCK_M_S for some. Howev...more >>

I am attempting to start replication and the logreader is stuck on initialize then goes to "The process could not execute 'sp_replcmds' on prod_db". I do notice that there are 3 logread.exe processes running. When I stop the logreader agent, there are two still running. I stopped the SQL ag...more >>

I know there is a querytimeout setting of 300secs or 5 mins ?What is the distribution agent doing or not doing maybe that it timeouts in 300 secs ? If the distribution agent job is blocked , will that cause a timeout too ? Can someone give me possible scenarios of when the timeout occurs . Using ...more >>

How to output the distribution agent history/output to file ? I want to start debugging it. Some google thread mentions to set outputverboselevel to 3 ..but where do i set it ? where do i enter it ? ...more >>

I have setup tranasactional replication and noticed that the distribution agent jobs are blocked. And i have transactional replication to run in continuous mode. Is there a timeout period for when the distribution agent connects to the subscriber ? Does the distribution agent keep polling the su...more >>

All, I've worked with SQL Server 7 Replication in the past and it was always a pain in the neck when we needed to add a new table. I've heard from folks that SQL Server 2000 replication does a much better job when it comes to schema changes. I've read their BOL section on Schema Changes on ...more >>

My agent have stop and not restart i have these errors [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000] [000] Unable to connect to server '(local)'; SQLServerAgent cannot start i have change the "service startup account" from local system, to another users the he ...more >>

Hi experts, I am able to replicate successfully between databases within the same domain. However I could not replicate between databases across different NT domains, it gave me the error "the process could not connect to the distributor <distributor name>". Could anyone please kindly advis...more >>

Hi, I have a Windows 2K SP4 Server with SQL Server 2K SP2. When I try to create a publication on a database, I have these error : xp_execresultset: unable to get a bound connection back to server (Source : SERVEUR (Source de données) ; Numéro d'erreur : 50007) The instant capture is not c...more >>

I have created trans replication between 2 servers. When it starts the snapshot transfer for the first time, I get this error: Column or Parameter #1: Cannot find data type T_Yes_No. The step failed. Any help is appreciated. Thanks, Bhargav Shukla ...more >>

My company has a requirement to do the following: 1) We need to know the last stored procedure that is called during replication. The reason for this is because we need to add a line at the end of the procedure to the effect of 'If replication was successful, UPDATE Synchronization SET SyncDa...more >>

I setup a merge replication system, for one database, between 3 servers, like this: - First server as a Publisher; - Second as a subscriver of the first one and as a publisher; - The third server as a subscriver of the second one; It happens that the hard disk of the second server failed an...more >>

I make the following steps to make a replication: \Replication \\Publication \\\Configure Publishing,Subscribers and Distribuition Then open the wizard with two choices 1) Make 'Myserver' it own distribuitor; SQL Server will create a distribuition database and log. 2) Use the follo...more >>

Can some one tell me if it is possible to synchronise/replicate an access database with an SQL Server database held on different servers ? Basically I have an access backend on one server which once a day needs to be replicated on an SQL Server box on a web server. Cheers ...more >>

how can I learn size (kilobytes or megabytes) of a table? ...more >>

Hi HIlary, Thanks for your prompt replies. I just wanted to clarify , to make sure that i am understanding this right. In the replicatin script you sent... the publisher has the folowing table test_vertical-filter (charcol1,charcol2,charcol3,charcol4,charcol5,charcol6,char col7,) and the ...more >>

I have created a publication on the primary server and setup the pull subscription on the subscribers. But when I go back to the primary server to run the replication manager, I can run the snapshot, but the pull subscriber is greyed out. I do not have any option to start that. Anyone ha...more >>

Hi all! I've been asked to set up replication between 2 databases. The publisher contains a table that has 2 columns. The subscriber should get a copy of the table, but with one additional column. This was the first problem. I created the destination table on the subscriber and added the extr...more >>

I am trying to use the SQL Server Distribution ActiveX control in Visual C# to trigger the replication of a snapshot that has already been created at the publisher. The replication is working correctly, but the "status" event is not triggered. I have attached an event handler, but it never app...more >>

Hello All, I'm trying to filter several table vertically for merger replication on SQL Server 2000. One table has been problematic. When I get to the end of the CreatePublication dialogs in EM and press 'Finish', I get an error message "Option table could not be added. Warning: rowId ...more >>

Hello: Can somebody comment on the following INSTEAD OF UPDATE trigger? When I make the change in Enterprise Manager, a row change does change the value but when I refresh, the change is lost! I have a similar logic on the INSTEAD OF INSERT trigger and that works fine! CREATE TR...more >>

I am trying to replicate a database(merge replication) with a table that looks like this ( Script_no PK , NOt null Script_name char User_lock char ) The user lock is a field which identifies who is accessing the script at a particular time (locking it ...more >>

I am hoping someone can help me. I am new to SQL server 2000, and I am looking to setup replication at a client of mine. I have been searching the internet, and I cannot find anything on how to do this!! can anyone give me step by step instructions or point me in the right direction? I keep...more >>

hello, i have set up a merge replication between a database on my desktop and one on my laptop. using the desktop as the distributor i have successfully published my stored procedures and views in a couple different publications. however, when i make changes to these objects on my des...more >>

I am currently looking at utilizing SQL Server 2000 replication as a solution for a Stand By solution. My questions are: What would the topology be... e.g. central publisher with remote distributor and updating subscribers. I say this because all production applications would need to acce...more >>

I'm a programmer and am kinda frustrated at how badly our setup is with respect to promoting sp/schema changes from dev --> test --> stage --> production. When programming in C#/vb.net with vs.net everything works perfectly with source safe. Multiple dev machines (each programmers) has his/her...more >>

I am learning replication. I have implemented transactional replication between two test servers. A REPL-Snapshot job was created and it is scheduled to run every day at 23:30. It was my understanding that this initial snapshot runs only once at the creation of transactional replicati...more >>

Setup: - MSSQL 7.0 (SP2) running on NT 4.0 (SP6) - Merge replication as follows: Server1 is the publisher, and Server2 and Server3 are subscribers. Data comes in through Server1 and Server2, Server3 is for queries only. Server1 and Server2 are synchronized at 4am, and then Server1 and Ser...more >>

Hi experts, I created a new publisher (Pub1) in on a SQL Server machine (Ser0). I tried to create a new subscriber (Sub1) to Pub1 on another SQL Server machine (Ser1), then the subscripting process failed and I got the error "cannot connect to distributor Ser0". Could anyone please kindly ad...more >>