I just installed SQL Server 2005 CTP and I dont see any kind of enterprise manager or anyway to setup replication. I look in Visual Studio 2005 and still dont see anything that looks like you can setup replication. What am I Missing?...more >>

after i disable replication. the distributionDB is still there. where i try to delete it . a error message occured as below: Error 3724: cannot drop the database because it is being used for replication please help Cheers nick ...more >>

The process could not initialize 'SSCE'. Check to see if the component is registered correctly. anyone knew how to fix this error nick...more >>

I've got SQL Server Developer installed on my laptop. I'm trying to get merge replication to work, but when I try to create a new publisher, when I select the option to make SQL Server on my laptop its own distributor, I then get an error msg. saying I've chosen a local system account, and rep...more >>

Pls advise, i use merge replication as pull, in replication data including some image data. Few records are just ignored and they do not appear in subscriber database, what i can do to make the databases fully synchronized? Mndr ...more >>

We use a third party monitoring system that polls perfmon statistics on different servers and generates alerts if a threshold is reached. For general SQL tasks like backup, I programmatically set/reset User Settable counters (10 in all) through system stored procedures sp_user_counter[1...10] ...more >>

Im doing some testing on Immediate Updating Transactional Replication. I generated a script to drop the Subscription and Article to a particular table to add an Identity column on it. After that, I re-added the table to the Publication and re-snapshotted the table. No problem and all is good at ...more >>

How long do records stay in this table? Is there a way to adjust the setting? -- SQL2K SP3 TIA, ChrisR ...more >>

First of all, would like to thank everyone on advance for any assistance you can render!! I've just got a couple of quick questions and looking for mostly feedback and opinion versus cut and dry ansswers... - I was wondering what is the TRUE impact/overhead of the various SQL Server Repl...more >>

I get 2 questions which need quick answer: Setup replication between Srv1 DB A (Distributor and publisher) with push publication to the subscriber Srv2 DB AB First qestion: many table get identity value set to YES on publisher, these values are lost in subscriber, but i need to get identic...more >>

Hi, I try to delete the database 'db' and get the errormessage 3724: Cannot delete the database 'db' because it is being used for replication. I called the stored procedure sp_removedbreplication 'db' and I set the colmun replinfo to 0 in the systemtable sysobjects for all objects. But after...more >>

as subject Thanks nick...more >>

this is for a class.=20 created subscriber DB with no problem, snapshot replication agent, = everything seems OK, but it won't copy over the user tables, only system = tables. it does not seem to run at all. no log files. i ran the script = suggested earlier in this newsgroup sp_changepubli...more >>

I cannot detach a db because replication is enabled . I wanted to detach this published db so that I can move the files to another drive . But at the same time, dont want to drop replication to do this. Is there a way to be able to detach the db without dropping replication . ? ...more >>

What is the best way to sync data between a publisher and subscriber thats out of sync without reestablising replication i.e. reinitialising the subscription and pushing all the data again.. Any handy scripts that I can use ? Thanks ...more >>

How can I check if the transactional replication is set up in continuous mode or on a set time such as replicate once every hour ? Thanks ...more >>

Hi, I understand if I use Immediate update from Subscriber to Pulisher, i will use the function of DTC, how about if I make a schedule e.g. every 1 hour, when it runs (Push/Pull), does that use DTC also??? Second ? is do i have to use Remove Server to run or I can use Linked Server? ...more >>

We are using merge replication with 600 users over a nationwide wan/lan network. For the most part it works, but occasionally some changes will not be merged to the agent. All changes make it to the server, but when users sync the changes do not come down to them. Someitmes if they do multip...more >>

I have a VB.NET program that is executing the SQL commands to setup replication. I am getting an error (A severe error has occured) on the sp_addmergepubliction command. I did setup a profiler and notice one area: sp_adddistributor was found in the text of this event, the text has been repl...more >>

Hi, Please help, I am new to replication. I have setup a vpn connection from one computer to another. e.g. Computer X and computer Y. Both are in different area of the city. Both computers have mssql 2000. The source database is in computer X. I like to replicate the data in computer X to ...more >>

Is it possible to have 2 different transactional replication models/publications coming from the same database (using same tables sometimes but with different fields and the same fields sometimes) to two different subscriber databases on two different servers? A yes No answer is fine and I ...more >>

We have the following configuration: Transactional replication (one way); Publisher and distributor are local, with subscriber through a firewall and slow WAN link overseas; 23 GB database; What is the best way of setting up replication in this scenario? If you do a push subscription, with...more >>

In regards to Transactional Replication, using a pull subscription through a firewall (distributor and publisher are on the other side of the firewall) and SQL authentication - is anything other than port 1433 required for this to work?...more >>

In regards to transactional replication using a pull subscription (set to continuous) - the distribution agent runs on the subscriber. How does the distribution agent know there are transactions available at the distributor? Does it continuously poll the distributor, or is it notified by the ...more >>

Hi, we have a database wich used merge replication. We disabled merge on this db, but '%onflict%' system tables persists, leading to error when trying to drop them. How can I drop those tables? TIA, Roberto Souza. ...more >>

hi, If I have one publisher and more than one subscribers, when i check on the option "Immediate updating", i understand what it does is to update the data back to the publisher immidately when I change data in the subscriber, but how about other subscribers? to make it clear, when i updat...more >>

Transaction replication: Please help. I am new to replication. I have setup Transaction replication between two databases. The replication is running. I now need to drop a replicate table in the source database but it would not let me. I don't want to remove the whole replication inorder to ...more >>

hi, Every time when i create a Distributor on a local server, it always said Error 14234: The specified '@server' is invalid (valid values are returned by sp_helpserver) i just want to create on in my local hard drive... any idea? Ed...more >>

Scenario: Two sql servers connected via WAN(central US and western US). Requirement: Union the results of a proc from 3 identical tables in each of these servers. Data is updated in these tables every 30 seconds or so. Result of the union needs to be returned every 2 minutes. Amount of da...more >>

Hi, I have created a transactional replication on SQL Server 2000 with SP3. Only one database is being published with 70 tables. But when it begins to replicate data the following errors occured ""The process could not bulk copy into table 'tablename' "" Violation of PRIMARY KEY constrai...more >>

Does anyone know how much time (approximate) I should allocate to set up Transactional Replication on a SQL database that is 20 gig in size? ...more >>

Hi, I am using Merge Replication and have filtered some of the tables for teh subscriptions, however, everything was working fine, then all of a sudden, I get this error. (See below) Does anyone know what would cause this and how I can overcome it? Thanks in Advance Warren *********...more >>

Ok, this is a strange problem, my company uses a software solution that has a SQL backend, the solution is based originally from an as400 database and when the company migrated it over to SQL they did not add Primary or Foreign keys to the table. now are problem, we do a lot of reporting off ...more >>

Dear Friends Thanks to Pual. Now if i want to do the following solution suggested by Mr. Paul it is giving me problem as when i take the database backup it is 1.2GB and i can not transfer this big file everyday from my branch to main office. ( takes too much time ) so what i did is. ...more >>

hi, I am thinking if Transactional backup is based on the data in the Transaction Log. what if i set up a the Log Reader to be run every 1 hour, but within that 1 hour, i do a transactional backup and issue the command "CheckPoint"!!! Can the log reader still be able to read what i have c...more >>

Hello, im using Visual Studio 2003 as an Admin. On my maschine runs a SQL-Server for development. The pc isnt a LAN-Client. Now I want write a PocketPC-application which is using one of my SQL-Server-DB. I want only copy the data from the desktop to de PocketPC (SQL-Server CE). What can I ...more >>

Hi, I am trying to replicate blob in MS SQL 2000, I know it is not advisable from performance point of view but this the requirement. I am getting that "The agent is suspect. No response with 10 minutes" from snaoshot agent. Do you know how fix it? I can increase the agent profile set...more >>

Hello - I recently setup replication here & I have a question. In doing an audit of the SQL Servers the other DBA & I notice a linked server between a dev box & a prod box with a read-only login called LinkedServer_RO to prod. Neither one of us recognize this linked server & it's against the...more >>

Hi, I have two server, One is a publisher and one is a subscriber with Pull Type. After I use "Disable Publishing and Distrubution", I sucessfully remove any entries in the Publisher Server, but there is still an entry under the "Replication" --> "Subscriptions" with the Pull type info. Ho...more >>

If replication ever blows up with an error like: "The row was not found at the Subscriber when applying the replicated command." There is only one way I know to fix it: Read the Last Command in the "Distribution Agent Error Details" box: {CALL sp_MSupd_AcctHistory (NULL,NULL,NULL,NULL,...more >>

Hi, I am trying to replicate database over internet using transactional push replication. Both publisher and distributor are on single server. In one sided replication, i.e. simple replication it works fine. But when I configure it for immediate updating subscribers with all insert/update...more >>

I tried this, and used MS article 818334. I found that the SQL Server Name was not the same as the Computer Name. However, when I try and drop the SQL server name, I get a message stating that the SQL server does not exist. So, I cannot rename my SQL Server 2000 server. What now? -- Wack ...more >>

Im leaving my company and trying to help out with finding my replacement. Below is the job posting as listed on Dice. Please note this position is for a real DBA. Not a Developer or Network Admin with some DBA skills, but a real DBA. Send resumes to itjobs@nextestate.com. If you mention "Chris ma...more >>

Hi, I would like to hear opinion from experts. Assume I have 3 warehouses and 1 Head office. I want to build a centralized Subscriber. should i use "3 Publishers/3 Distributors and 1 Subscriber" -- each sever will have 1 P and 1 D or "3 Publishers and 1 Distributor and 1 Subscriber" ...more >>

Hi What will happen if the Publisher or the Subscriber shuts off while replication is taking place Will that cause any problems or it will simply continue where it stopped? Thank you, Shmuel Shulman ...more >>

Hello, We have a merge replication setup across telephone lines. I want to add a new table - how can i do it without publishing the whole database? Regards Ishan...more >>

hi, i am Oscar from Spain I have a mistake in Transactional publication. The Error message is "Could not bulk insert. Bulk data stream was incorrectly specified as sorted" I have checked in publisher and subscriber the command sp_helpsort and the result is equal in both of them. Can you ...more >>

I'm new to SQL Server replication and my company. There are several servers replicating data. How can I determine if snapshot, transactional, and/or merge replication is being used? Thanks in advance for your help! apf...more >>

Hi, I have made a replication since 2004-08-21. it works well, but recently i got a problem. When i want to delete some records in a table, an error occur. the message is: Cannot insert duplicate key row in object 'MSmerge_tombstone' with unique index 'uc1MSmerge_tombstone' The ...more >>

Hi Team, Not sure of the best solution. I have two SQL servers in different parts of the country connected via a 3mb VPN WAN. Both are used for the same front end application but use different databases. I want each server to be able to take over the others database in the event of a dis...more >>

Transactional Replication. Box1: Publisher Box2: Reporting only Subscriber Box3: Updateable Subscriber If Box1 modifies data, it obviously goes to both Subscribers. But if box 3 modifies data, will it show up on Box2? If memory serves correctly, it will not by design. Is there a way to cha...more >>

I have a situation where I want to use transactional replication and maintain the IDENTITY property at both the publisher and subscriber. I want to do this to enable an easier failover if I need to. (I have custom code to reseed the IDENTITY values in case of failover) My primary goals are to...more >>

Hi, I need to add a column to a replicated table. Is there a way of adding a new column without dropping the whole replication? I went through the script specified at http://www.replicationanswers.com/AddColumn.htm But I have a question. I have created merge replication by FTPing the sna...more >>

I am trying to setup transactional replication. When I click FINISH on the Replication "publishing, subscriber and distributor" setup wizard, I get the following error: ******************************* SQL Server Enterprise Manager could not configure "MYSERVER" as the Distributor for "MYSE...more >>

Dear Friends I have a SQL Standard version and due to same i am not able to do the log shipping for the database i want to create a backup server which is only for analysis and the same need to update only once. I can not set the replication between the server as the Database is not com...more >>