If sp_autostats <tablename> will display the current statistics status of all indexes in the authors table, is there a counterpart for sp_createstats? Based on Books online, sp_createstats will create statistics for all eligible columns for all user tables in the current database. I'm afraid to exec...more >>

I have SQL Server 2000 transactional replication and it works fine. I needed to alter a table and add two tables to the database and the replication article. I delete the transaction replication subscription. I tried to alter a table and received an error stating that the table ...more >>

Using DMO I have one SQL server subscribing to another, however the the subscription is not a continuous one. Having made that is in EM and then using code to compare that subscription with the one the program makes I cant see any differences. What properties do I have to set, or method to c...more >>

I get the following error when trying to syncronize 2 databases configured for merge replication: The subscription to publication '<DBName>' is invalid. (Source: Merge Replication Provider (Agent); Error number: -2147201019) ----------------------------------------------------------- -----...more >>

I have an issue with one of my subscribers getting the dreaded "The Publisher has been restored from a backup whose schema change version is different from the Subscriber." error on one of the publications. I have a total of 6 publications and the error only occurs one of them. After receivi...more >>

Hello I use a merge replication and I can see many conflicts (in differents tables) having the same source error. The error message in Conflict viewer says The row was inserted at 'Publisher.DataBase' but could not be inserted at 'Subscriber.DataBase'. INSERT statement conflicted with COLUMN FORE...more >>

We have an application that runs with MS SQL 2000 (SP3a) which is used for tracking information from multiple sources. We are shortly going to be setting up replication of this database with a secondary location, with a third location planned by mid year. We know that there will be other locat...more >>

Hi - I am an extremely novice user attempting to use transactional replication. I successfully ran the replication and then opted to remove the subscriptions, publications and so forth and start again. I did not remove the distributor. I may have removed jobs associated with the distributor t...more >>

Thank you for all the guidance. I guess I have my alternativities clear. Thank you very much. Now I have another issues to address and if someone has experience in this I would really appreciate the advise. Right now we are implementing the second site, eventually we'll have 5. 1. I need t...more >>

I have merge replication set up with a publisher and two subscribers. All of my primary key fields are set for autoincrement (not for replication). The articles in the publication are set to force the subscriber to use a range for generating unique primary keys. Things seem to go well for a while...more >>

dear friends, any idea that can make the merge agent doesn't replicate the updated data from the subscriber? although the agent status is successful and this message appear ' no data needed to be merged' , although there was data modified...more >>

Dear Friends, i'm facing a strange thing with merge replication , the merge agent is running and working successfully displaying the message 'no data needed to be merged' although alot of modificatins is been made to the subscriber. and i stoped the agent and run it again , same message...more >>

How do I stop SQL Server Agent in SQL 2000 via a SQL statement?? Thanks.......more >>

Running SQL 2000 & Win 2000. My main server was upgraded/replaced today. We stopped SQL on the ond server and copied the dBs to the new server, which has the same name as old server. I receive the following message on all my subscriptions from my remote locations. The job failed. Un...more >>

Hello, I have a problem when trying to publish articles for merge replication. During execution of the snapshot agent I receive the following error "The process could not bulk copy out of table '[dbo].[table_name]'. Can anyone help me with this problem? Any help at all would be great...more >>

A few days ago I posted a problem I am having with push, one way, transactional replication failing to replicate updates to the subscriber. The identity field is set to Not For Replication on the subscriber and the inserts work, however, my updates are failing with a Cannot Update Identity column. O...more >>

Hello Everybody, Thanks to all of you that have answered my basic questions, I really appreciated. I have some doubts related to the updating subscriber scenario. * When we talk about updating subscribers, we are talking about transactional publications ONLY ??? * If I imp...more >>

for a couple hundred users... These folks currently replicate several Notes databases at least once a day Do you think I'm crazy for considering a new solution with SQL Server in the middle and MSDE or SQL Personal edition on all the remote machines? Is it feasible or am I trying to fit a sqaure...more >>

I have merge replication set up with a publisher and two subscribers. All of my primary key fields are set for autoincrement (not for replication). The articles in the publication are set to force the subscriber to use a range for generating unique primary keys. Things seem to go well for a while...more >>

Hello, I have this problem, I have transactional replication setup with 2 table as article for a publisher. Consider a transaction which inserts one row into each of these table in the publisher database. At subscriber database one of the commands suceeds and the other fails (lets say be...more >>

Hi, I had did replication from SQL Server 2000 to Ms Access in same server. Now, how I do it replication back to SQL Server from Ms Access in same server also. very Urgent!! Thanks You....more >>

I have a subscription that has expired. I need to be careful to preserve the data that resides at my subscriber. I have two weeks worth of data at the subscriber that needs to be synchronized with the publisher. Any recommendations on the best approach to get my subscriber back in sync? ...more >>

Hello Everybody??? Just a simple question. Do I need sp3 or sp3a in order to set up replication???? Marlene A Roman ...more >>

the servers i have is like that: SERV-A is publisher, SERV-B is subscribor to SERV-A SERV-C is subscribor to SERV-B I have sqlserver which the database on it is configured as publisher and subscribor at the same time, I have duplicate record in a specific table on that server only(SERV-B), w...more >>

Hello, I hope everybody is doing ok. I'm trying to set up my first "replication". I have the standard edition of SQL SERVER 2000. While reading the documentation I am trying to identify the the objects in the Enterprise Manager that the documentation is refering to. For example Replic...more >>

In SQL2000, SP3, We want to periodically refresh our read-only subscribers with the latest schema and data (including FK's, indexes, etc) whenever we role out a new software release. The database is relatively small and we can currently disable publishing\remove subscribers, and add them back i...more >>

Hi While setting up the replication using sp_... I get the error 14070 Could not update the distribution database subscription table. The subscription status could not be changed. Does any one have any info about this. I don't have a clue about this error and I searched in KB, Sup...more >>

I want to setup a publisher, distributor and subscriber on the same machine. While configuring my distributor using Wizard, I received the following error: Error 18483: Could not connect to server 'HONB" because "distributor_admin" is not defined as a remote login at the server. I am using...more >>

Dear Friends I am facing problem from Appying the scema automatically as it is giving error that the script can not be propagated at subscriber hence i want to manually apply the schema first at subscriber please suggest if the same is possible. Best regards sharad...more >>

Dear Friends I am getting the following problem. Kindly help The schema script '\\server2 \f$\sqldatafiles\MSSQL\ReplData\unc\server2_MAINSQL_MAINSQ L\20040425110134\ListOTH_8.sch' could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -...more >>

I have a customer who has Access databases at many sites across the country who wants the data replicated nightly to a centralized MS-SQL Server using broadband connection (Cable, DSL, etc.) I have very limited knowledge of best practices to accomplish this reliably but know their current sol...more >>

Consider the following scenario: I got 2 webservers (2003) using NLB. I want some kind of common data store (SQL Server). I need this data store to be fault tolerant. I don't have any more machines. I don't have an enterprise licence for windows. How do I solve this??? ...more >>

I'm doing database replication between 2 servers (IBM 250 & IBM 365 and my database got around 8000 tables..and the performance is very slow. May I know what is the best way to replicate the database Thanks for your valuable reply..have a nice day! : My Server: Win 2000 Advanced Server, SQL S...more >>

I had Merge replication working fine between two SQL 2000 servers for months... then the subscriber server had a hard drive crash and we rebuilt it... I am now having trouble re-establishing the replication with the subscriber. On the publisher I have deleted the subscription and reestablished it.....more >>

Hi, Can anyone tell me whether replication can help me solve a problem when my publisher has a very tight firewall? Specifically, they absolutely will not enable ports, MS Proxy Server, or VPN. They are willing to periodically forward a file through FTP, but there is no way they will allow logi...more >>

Hello I want to create two transactionnal publications on one table. Each publication will deal with certain columns. Example : Base : DB_TEST Table : T_TEST columns : id (int), data1 varchar(10), data2 varchar(10) Base : DB_TEST2 Table : T_TEST2 columns : id (int), data1 varchar(10),...more >>

Error message: "The process failed to get information about the Interactive Resolver from the registry" I am using MSDE to subscribe to a central 2000 database using a pull subscription and the active X controls. However, the default resolver fails to operate. I have a call in with Product Supp...more >>

I'm running Sql 2000 SP3, on a Server 2003 system. I am testing merge replication between two sites. When the database is published, everything seems to work fine. If I delete the publication and try to create another publication, I get an error saying that the publication does not exist...more >>

Greetings! Any help with the following situation would=20 be greatly appreciated. We have a push transactional=20 replication of a subset of the tables in a production=20 database involving 3 machines; the production db machine, =20 a distribution db machine, and a subscriber db machine to=20 ...more >>

I'm not able to resolve conflicts using the conflict viewer because I have timestamp columns in my tables. Can I manually resolve these conflicts by making the necessary changes to the data? I'm using filters on my articles and I'm noticing that replication is changing rows in the table tha...more >>

Hi Can anyone tell me if you need the same registry entry as in 6.5 for replication over firewalls for 7.0? Ref -Microsoft Knowledge base article 164667. http://support.microsoft.com/default.aspx?scid=kb;en- us;164667&Product=sql Thanks...more >>

Hell Im trying to create a merge replication. I've a 2xSubscribers and a distributor/publishe My published table has fieldnames describing what server this row should be published. When I create my replication a use a filter like this: ... where target_server = host_name() I want to publish ro...more >>

My company has several MSDE databases (subscribers) and one SQL 2000 server (publisher and distributor). All computers are a member of the same domain. The Merge Replication between all users of our database did function well until recently. After the Snapshot agent made a new snapshot, th...more >>