We have a SQL Server 2000 for web reporting purposes. SQL Server is maintained by a hosting domain. Owner of domain has given us IP to access the SQL Server. Now whenever our developer want to make some changes in database or stored procedure , they do it by accessing sql server instance on the...more >>

Is there anyone who has succeeded with replicating either a SQL 2005 server or SQL 2000 to SQL Express or MSDE? something peculiar about my setup -(which is how it needs to be) is that I have both laptops and desktops that often become detached from the network, these laptops cannot have f...more >>

Hi, all We have prod. database and test db(new version of prod, table fields changed). Production db has users connected and updating records and I need to have user transactions in production db updated in test db as well. I can't use log shipping to sync them because of the table structur...more >>

Is there any new functionality in SQL 2005 that allows you to deliver a different subset of data per client by supplying a parameter to filter by? Example: I have a product_warehouse table that contains all products for all warehouses. I want to replicate this data onto PDAs with SQL Mobil...more >>

I am in the process of proposing a SQL 2005 Merge replication solution to my company which will allow us to move data to and from various locations around the world using a Satellite link. One of the scenario that must be dealt with is the potential loss of the satellite link for an extended a...more >>

Hi to all, I’m evaluating the merge replication mechanisms. The environment that i considered is the merge replication between Microsoft SQL SERVER 2005, as consolidated database, and SQL Mobile (SQLCE 3) as remote database. During my evaluation, I found an important issue that, if confirme...more >>

We have Wan Cenario with about 180 site. We need replicate many tables, that grow up the subscriber database to almost 20 Gb. I intend to make Transacional Replication. All test with pull subscriber is ok, but without @independent_agent, @immediate_sync,@allow_subscription_copy options , i mean,...more >>

Are you writing a book on SQL Server 2005 Replication? If so, when is it coming out? I love your book on SQL 2000 Replication and highly recommend it....more >>

I need to get data from several client SQLExpress PCs to a central SQL 2005 server over the Internet. I'd like to pull this data from the server instead of pushing from the client PCs - but not a requirement. I understand SQLExpress only supports subscriber replication only. Once uploaded data...more >>

We are receiving this error message when starting a merge agent. Publisher/Distributor is MSSQL 2000 SP4. Subscribers are MSDE 2000 SP4. The error message in the Agent is "Syntax error near '-'" Last command: create table #belong_agent_-1893386031 (tablenick int NOT NULL, rowguid unique...more >>

Hi, I created a transactional publication and I included tables, sp's, views and a function. It failed because it was trying to create some of the views and sps prior to the tables being created. I did a bit of googling and it appears as though you can only change article order in merge repli...more >>

I thought I would be able to apply different horizontal filters in different publications to the same articles but when I try and do this I get an error message. I can't understand how this filtering is useful if you can't use it to partition different data to each subscriber. I can define ...more >>

SQL 2005 merge replication, pull subscriptions only, clients are SQL2005 or 2005 express. Using replicaition monitor, I enabled a couple warnings and set thresholds. I also enabled/configured alerts to send emails to myself. The warnings work, but no emails get generated, (no events are writ...more >>

when replication falls over (for whatever reason) is it possible to reinitialise automatically all subscriptions and all agents...more >>

Hi what command syntax could I use to check for synchronicity between two replicated databases? ideally id like some way to check random objects on server A against same random objects on server B, and a way to check defined objects - table size, amount of entries etc etc on A against B. ...more >>

Hi Im creating a disaster recovery solution for my company, and accordingly have to test SQL replication to death. With regard to subscriber types, I know that a pull replication creates less load on the publisher than a push, but as I need to test both types I therefore need to strictly...more >>

Hi, I am trying to replicate a table which has an identity column (first column) as the primary key. The table replicates fine, however, the key is removed. I manually placed the key on the replicated table but when replication is ran again the gey is removed. Can I set transactional replicat...more >>

Hi, Having trouble connecting SQL Express with SQL 2005 for that matter. Just tried to make it a subscriber to a known good publications created on both, but constantly getting error below. I know that remote connections are enabled. Any ideas? Thanks! Jennifer TITLE: Connect ...more >>

I've set up my two SQL standard servers and have my database mirrored now. Questions : 1. Is the performance of the principal affected by communication errors with the mirror ? it won't hang waiting for the mirror server to become available before servicing the next request or anything ? ...more >>

Greetings all. I have a SQL Server 2000 database that I need to temporarily detach for a copy to a new server. However, the task cannot be executed because SS reports that the database is in process of being replicated. This should not be the case: all agents have been disabled and i show...more >>

We have few large databases that we are trying to log ship the transaction log to another location. After the weekly maintenance plans run the transaction logs are very large and take to long to copy to the destination server so they can be applied. I wanted to know what other folks have don...more >>

I am using transactional replication with one queued updating subscriber as a high-availability solution in a 24x7 environment. Several of the articles combined total 100 gigabytes of data. When applying the snapshot, I generally choose the option to drop the existing table and recreate it. ...more >>

Hi; I have scripts that drop and recreate development databases from VisualSourceSafe every night. As part of this process I have TSQL procedures that set up replication, create publications and then subscribe other databases to the publications. On the heels of this, I load test data into th...more >>

Hi, Our Environment: win2003, SQL Server 2000 SP4 We have two SQL servers - primary and secondary. We are using merge replication to synchronise tables between these. Primary & Secondary SQL Server services are running under the domain administrator. Application connects using its own user...more >>

Has anyone heard of any known issues with replication after upgrading to SQL Server SP4? Any insight is appreciated. Thanks! ...more >>

Hi All: We are facing a strange problem on SQL Merge Replication: This is Pull Subscription setup over VPN. The replication ws running = fine, until it stopped and started throwing these messages: "The Process could not enumerate changes at the Subscriber" "Invalid character value for cas...more >>

I have a queue reader that recently started failing with the following error msg - Executed as user: DMN\wssql. Replication-Replication Transaction Queue Reader Subsystem: agent [SSD05].09 failed. Queue Reader aborting. The step failed. [SQLSTATE 42000] (Error 14151). The step failed. H...more >>

Hi All, I'm having a problem with a script in sysmergeschemachange that cannot be propogated to the subscriber: The schema script 'if object_id(N'[dbo].[UNIT_OF_MEASURE]') is not null exec('ALTER TABLE [dbo].[UNIT_OF_MEASURE] ADD CONSTRAINT DF_UNIT_OF_MEASURE_CONVERSION_RATE_WB DEFA...more >>

Hello, i have a problem with this.. it does replicate the data, but if i change something in the server, it does not replicate this, replicate the old data. i must to restart the agent to catch the new data... but this is not the we want it... is there something wrong??? something that i m...more >>

I currently have a SQL Server 2000 database with a push subscription. I am wondering if it is possible to change the order that articles are propagated to the subscriber. I currently have a table, say table A that is used in view B. However, for a variety of reasons I need to change the name...more >>

Hello, I keep reading that peer-to-peer does not do conflict resolution but it must do something when the same row attribute changes in two places? Can anyone explain this to me? Thanks, Lauren...more >>

Hello everyone, I hope somebody will be able to help me understand this one: In my vb.net application I am replicating from SQL Server 2000 using SQLMerge Object and SQLReplErr Object. I have my replication objects developed and all is working correct. I now wanted to make my application...more >>

Hi I have a sql2005 server and I want to replicate one of my databases to a second server to act as a reporting server to reduce the load on the primary server. I would like to use mirroring so that the server is up to date but I am having problems setting this up. I am trying to move/copy ...more >>

Installed SQL2005 on server, now I changed server name from "oldname" to "newname" The database is on server "newname" now but I still see usergroup oldname\SQLServer2005MSFTEUser$oldname$MSSQLSERVER.... in security-> logins -> Here's the error message when I start a new publication in ...more >>

Installed SQL2005 on server, now I changed server name from "oldname" to "newname" The database is on server "newname" now but I still see usergroup oldname\SQLServer2005MSFTEUser$oldname$MSSQLSERVER.... in security-> logins -> Here's the error message when I start a new publication in ...more >>

I need to drop a column in merge replication where the column I need to drop has an index on it. The purpose of the drop column is to expand my FirstName column in a Customer table. 1) Create First Name Dummy 2) Copy data from FirstName to FirstName Dummy 3) Drop First Name Column 4) C...more >>

Hi I have an instance "A" to its replicate a database "AA" to an instance "B" to a database "AA" and works fine... but I would like to if is it possible to replicate the database "AA" from instance "B" to another new instance such as "C" example of replication A --> B --> C thanks in ad...more >>

Hillary I am trying to merge data from 4 SQL Servers to 1 server. The merge will be in one direction only, from all regional servers to the master server. I am mergin 2 tables. Some of the tables have an index on a field. There is a possibility where there maybe duplicates on that field b...more >>

We are in migration from SQL 2000 to SQL 2005. While we are running in SQL 2005 we want to do a log shipping to our old production servers for at least 2 to 3 weeks if in case anything goes wrong we need a fallback. Is there a way I can do this Please let me know -- Thanks Naveen...more >>

I am using SQL 2K with SP4 and using transactional replication with PUSH method. I want to create a SQL agent job with the following steps. 1. stop log reader agent 2. do something 3. Start log reader agent What is the proper command for me to use in step 1 and 3 to stop and start log r...more >>

I have seen several posting on the Internet concerning the following error when using domain accounts for the SQL Agent and replication agents (which results in proxy accounts) with SQL 2005 replication: Executed as user: DOMAIN\svcacct. A required privilege is not held by the client. The ste...more >>

We are usign SQL 2K with SP4 and using transactional replication with push methodl. The distribution database is in the same SQL server as the Publisher database. Here is my question. In EM console tree, Replication Monitor -> Agents -> Distribbution agents, where are the entries ins...more >>

Hi, I am using 4 regional servers in peer to peer replication. In the .NET application, should I write custom coding to connect to alternate servers, or is some configuration level, automatic fail over is possible. Any help/link is highly appreciated. Thanks, Lalitha...more >>