|
|
|
April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 SQL 2K5 Custom Resolver (Business Logic Handler) Posted by SteveM at 5/28/2006 3:53:01 PM I have a system where certain data for a given record can be updated by
either the Server or the Mobile Device.
Upon replication we get a conflict.
The data that can be updated is in different columns.
'
I have tried to use column level tracking but it does not appear smart
enough to "me...more >>
URGENT-- Replication blown up. Posted by ChrisR at 5/26/2006 4:28:05 PM Pull Subscription, Remote Distributor (on the Subscriber), not Immidate
Updating, Tranascactioal Replication with both boxes SQL2K SP4.
I have no idea what to do here. I highlight Log Reader Agent and all of them
simply say "The step did not generate any output. The step failed". I RClick
and ...more >>
Synchronization error Posted by CrudeOil at 5/26/2006 3:18:25 PM Hi,
I've added a couple new fields to a table. There are 10 subscriptions
on this publication. Only 1 has problems synchronizing since. First
error is:
The merge process could not clean up the subscription to
'SERVER':'SERVER:'PUB'. (Source: MSSQL_REPL, Error number:
MSSQL_REPL-2147200965)...more >>
Anonymous Merge in 2005 Posted by David Chase at 5/26/2006 12:18:06 PM We have laptops using MSDE to synch with SQL 2000. We plan to move to 2005
and Express. We are using Merge replication and the laptops are anonymous
subscribers. In 2000 we setup the anonymous subscribers from Windows
Synchronization Manager by specifying the publication and subscription
...more >>
Replication - Replicating the contents from a view to a Table Posted by Query Builder at 5/26/2006 11:37:41 AM I have a complex query I use to populate reports. I need to move the
reporting environment from actual production database that gets updated
frequently. I have converted the reporting query into a view that pulls
information from many tables with complex joins
In my reporting databases, i have...more >>
HOW TO PREVENT DUPLICATE RECORDS IN SQL EXPRESS 2005 Posted by mca at 5/26/2006 6:06:18 AM Hi everyone!
I am a computer engineer and have recently upgraded to .net 2005. With
new data components available, I have decided to write a simple
database application in order to get familiar with the new aspects of
..net 2005.
Here is my problem : When I try to update a record on an sql ...more >>
Dropped Data - Merge Repl Posted by J Jones at 5/26/2006 5:52:02 AM I have a few subscribers that are complaining of dropped data in one of the
main tables that users update on the subscriber machines. When they
replicate, the agent history indicates there were conflicts, but when I go to
the conflict viewer, no conflicts show up.
The dropped data does not...more >>
How to change retry times for Distribution Agent? Posted by FJY at 5/25/2006 11:23:01 PM Hello,
I have two SQL Server 2000 using Transactional Replication over a VPN
tunnel. From time to time, the VPN tunnel is dropped and reestablished, which
made the Distribution Agent fail sometimes. I would like to increate the
retry times, could someone please tell me how to do that?
Th...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
What happens when session duration exceeds to Agent polling interval? Posted by JIM at 5/25/2006 11:14:12 PM I'm thinking of dropping the polling interval to 30 seconds. What is
the behaviour of the merge agent if it takes longer than 30 seconds to
synchronize enumerated changes fo a session?
...more >>
SQL Server Replication 64 Bit to 32 Bit Posted by sqldood NO[at]SPAM googlemail.com at 5/25/2006 9:47:29 AM Any known Issues ?
...more >>
repl_sub_restore_XXXXX Posted by Tigermikefl at 5/25/2006 9:21:02 AM Do you recognize the process below? Some sql housecleaning or what?
In my Sql log of my publisher/distributor, I get set of entries like:
Starting up repl_sub_restore_5014D8E0-86F8-437F-80A3-DD6C12EFE5E5'
Bypassing recovery for database
'repl_sub_restore_5014D8E0-86F8-437F-80A3-DD6C12...more >>
Merge Replication Security Posted by savvaschr NO[at]SPAM nodalsoft.com.cy at 5/25/2006 5:27:27 AM Hello
I want to ask about the best security scenario that i can follow in
Merger Replication.
I have a server with a static ip , a virtual directory there and a
merge replication on an SQL server 2005.
I am thinking of opening the 80 port only on my firewall and also open
a range of acceptab...more >>
Show pending merge changes Posted by babu.mani NO[at]SPAM gmail.com at 5/24/2006 8:32:55 PM I have changed Paul Ibison's stored proc a little bit. This proc
should wok for both Central and Branch database and lists for all
replicated articles, so parameter is optional. Also it eliminates
duplication.
Let me know if there is any flaw.
CREATE PROC PBS_sp_ShowPendingMergeChanges (@...more >>
Cannot add publication after applying service pack 1 Posted by Jacob Page at 5/24/2006 1:23:02 PM After applying service pack 1 to SQL Server 2005, I can no longer set up
publications. Here's what I'm attempting:
Under the Object Explorer of SQL Server Management Studio, I'm
right-clicking on [INSTANCE]/Replication/Local Publications and selecting
"New Publication..." After clicking o...more >>
Mirroring Questions Posted by Ian Jenkins, MCSD at 5/24/2006 10:54:04 AM Looking for some answers about Microsoft SQL Server 2005's new
mirroring technology.
1) When using a witness what happens if the witness crashes?
2) What happens if the Principal crashes and the mirror never becomes
the Principal?
3) What happens if you try to insert records into the m...more >>
Mirrorring and web.config Posted by Andrew at 5/24/2006 10:22:02 AM Hi,
I have setup my mirroring model to 'High safety with automatic failover'.
Accordingly to article:
http://msdn2.microsoft.com/en-us/library/ms366348(SQL.90).aspx
my web application should work without resetting web.config.
My Connection string is:
user id=<webUser>; Network=dbmssocn; ...more >>
Distribution size Posted by pardhiveswar at 5/23/2006 11:56:46 PM Hi
My disribution DB is automatically set and the databse size is about 800 MB.
now i am planning to set distribution database to fixed size as microsoft
recommends Can anyone tell how much can i set upto.... and that should not
degrade performance wise.
Your help will be appreciated
Th...more >>
Choosing a custom resolver form Merge Replication Posted by Alberto Silva at 5/23/2006 5:24:18 PM Hi,
Using SQL Server 2000, when choosing the "Microsoft SQL Server Additive Conflict
Resolver" resolver using the sp_addmergearticle, I get the following error:
"The resolver information should be specified while using the 'Microsoft
SQL Server Additive Conflict Resolver' resolver."
If I ...more >>
publishing more than one database Posted by Wingman at 5/23/2006 2:27:02 PM We are using SQL 2K with SP4 and push transactional replicaton with
continuous syn.
Recently we have a need to publish the second database on the same SQL
server where our first published database is on. My question is, the process
for publishing a second or third etc is no difference th...more >>
Manual Synchronize and Maintain Consistency. Posted by chad NO[at]SPAM gratisinternet.com at 5/23/2006 1:46:52 PM Manual Snapshot - Transactional Replication - SQL Server 2000 Sp3a
What is the best way to handle the snapshot process of transactional
replication under the following conditions?
1) Manual synchronization (semi-large database - 200GB)
2) Without locking publisher tables during snapshot (sem...more >>
Conflict Resolver - Changing Posted by J Jones at 5/23/2006 12:35:02 PM Does running the sp_ChangeMergeArticle to change an article's conflict
resolver require a reinitialization of the subscription? I performed a test
and it seemed to NOT cause a reinit - I changed from the default, to
Subscriber always wins, and then back to default, but I wanted to get some
...more >>
Peer to Peer Replication Error Posted by RL at 5/23/2006 4:03:01 AM Hello - I'm preparing for a migration from SQL 2000 and SQL 2005 x64. We
currently use transactional replication, but I think P-P is the right choice
moving forward. I'm setting up a test environment and have run into a
roadblock.
Config:
Server A: SQL Developer x64 (no SPs)
Serv...more >>
Replicator:Main DB insert turns into sp_MSupd on Replicator Posted by avigdor levy at 5/23/2006 12:32:13 AM I run into a problem with a Replicated table:
An "Insert into" ( in Main DB ) on the replicated table turned out in the
Replicated DB as an "Update" ( sp_MSupd ) on the replicated table.
Does anyone encountered this problem ?
Any suggestions ?...more >>
Filtering Columns in Transaction Replication Posted by Malarb at 5/22/2006 10:39:01 PM I currently have 2 scenarios that I need help with.
Scenario 1:
A column was added to a table using the standard ALTER command by mistake
(should have been sp_repladdcolumn) and now I want to publish that column. Am
I able to do this without dropping the column or forcing a reinit of the
s...more >>
@post_snapshot_script Posted by Daniel Jameson at 5/22/2006 4:59:04 PM Hi,
I have a transactional publication in SQL 2000. I need to GRANT some SELECT
permissions in the subscriber. I have the articles set to drop and recreate
tables when applying a snapshot, so I would like to use the
@post_snapshot_script parameter/option of sp_addpublication to run a
p...more >>
Remove table from Publication Posted by David Chase at 5/22/2006 2:23:15 PM We are using Merge publication, SQL 2000 and MSDE (on laptops). I need to
remove a table from the Publication articles.
1. Will the laptop users need to do anything when they synch or will they
just be informed that their subscriptions need to be renewed?
2. Will any updates on the laptops be...more >>
adding columns Transactional Replicatiions Posted by sqldba at 5/22/2006 9:02:00 AM i had a long discussion with my developer team & they were not convince with
sp_repladdcolumn & they decided with traditional way & then to re-initialize
SNAPSHOT. As it is not in my control so they gave me script to add new
columns for 4-5 tables/articles.
Alter table xyz add
col1 varchar(5...more >>
Rebooting server Posted by Elena at 5/22/2006 6:40:01 AM I need to reboot server which is pull subscriber. What is the right procedure
for doing this?
...more >>
Snapshot and file groups Posted by andsm at 5/22/2006 1:39:02 AM I try to create transaction replication and have problem with moving tables.
Snapshot agent generate schema for tables without file group, so on
subscriber the tables will be placed on primary file group. But I want it to
be placed on same filegroup as on publisher. Is any simple solution for ...more >>
Restore a database Posted by lara169 at 5/22/2006 12:00:00 AM Hi,
I am trying to restore a database (subscriber) that is used for replication.
When i trie it, I received this error:
Exclusive access could not be obtained because the database is in use.
RESTORE DATABASE is terminating abnormally.
Can anyone help me out ?
Lara
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |