|
|
|
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 Problem w/2005 to 2000 replication Posted by MikeG at 12/14/2006 3:25:12 PM When I add the option to add extended properties to the publication, create
the snapshot and then distribute I get the following error in the
distribution agent task:An invalid parameter or option was specified for
procedure 'sp_addextendedproperty'
Any ideas?
...more >>
Replication Scene Consultant Posted by Krisnamourt via SQLMonster.com at 12/14/2006 12:00:00 AM Hi Guys!
I work in Govern Department Bank. We just have many experiences about
Replication, meanly Transactional.
All evolution about Client-Server architecture in the past, make some choice:
 Many Distribution application at many sites located in many cities linked
through Wan (frame rela...more >>
transactional replication Posted by James Wong at 12/14/2006 12:00:00 AM Hi,
I have some problems in transactional replication.
Case 1:
When the subscriber goes offline mode, I add the same records in the both
size (distributor & subscriber).
After the subscriber onlines again, the error occurs.
Case 2:
When the subscriber goes offline mode, I delete the ...more >>
Replication Sql 2005 Posted by kapil at 12/13/2006 8:50:00 PM Hi,
1. Can we replicate tables with no primary Key. Will Sql server add some
type of constraint in tables.
2. Can we replicate Bitmap/Blob data.
What kind of replication is suitable for these scenario...more >>
Resyncronize publication and subscription Posted by Iter at 12/13/2006 7:49:01 PM I have two databases that are used for publication and subscription. One
table in subscription was droped by accidence and replication was failed.
After I re-create that table and Re-syncronize them, I still got failed and
error was like that table is not existed. No matter how I did, it was f...more >>
bidirectional snapshot replication? Posted by Glate at 12/13/2006 4:33:29 PM I currently have a list of users in a SQL 2005 database. Users are
authenticated based on their email address, and each user has a number
of areas they do and don't have access to. A website is used to add
users to the database, or to add area permissions for an exisiting
user.
I would like t...more >>
Distribution Agent Error: Syntax error or access violation Posted by Muhammad Shahzad Saleem at 12/13/2006 1:06:06 PM I am getting this error in the distribution agent that I setup for
transactional replication. The last command which failed is like "CALL
sp_MSins_CompanyName$Trans_ Sales Entry ("
The table name is lengthy and contains spaces too. I believe this is because
of the spaces in the stored proce...more >>
Run a Snapshot agent from a script or cmdline Posted by scooper NO[at]SPAM kustomsignals.com at 12/13/2006 7:15:49 AM I would like to be able to run a snapshot agent from a TSQL script or
from a cmd line. I have merge replication setup to several different
publications and would like to script all of the snapshot agents to run
on cmd rather on a schedule. I am using SQL Server 2000 with SP3.
Thank You in ad...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Unable to delete publication/subscriber Posted by Thyagu at 12/13/2006 3:51:46 AM Hi,
I had enabled snapshot replication between two databases in the same
dataserver. The replication was failing with error 'Could not find
stored procedure ''. (Microsoft SQL Server, Error: 2812)'. I thought
that I should have configured it wrongly. I'm trying to delete the
publication or at...more >>
Prefetch objects failed Error when added more than 2 table as arti Posted by John Luo at 12/12/2006 5:22:00 PM Hello,
I got error message "Prefetch objects failed for Database ‘MyDB’" when I try
to run the snapshot agent to create a snapshot. It is a SQL 2005 merger
replication. Further more I find it can generate the snapshot if there is
only one table in articles. If I add one more table the err...more >>
drop replication Posted by Q. John Chen at 12/12/2006 3:41:43 PM Here was my problem.
I have a database with replication. All I need to do was restore the
database from a backup (totally different data from another server).
The restore process was messed up because I was not aware there is
replication in place. So the database status is always loading. I ha...more >>
Is it possible to alter snapshot agent to not drop tables? Posted by mEmENT0m0RI at 12/12/2006 12:53:59 PM We've got transactional replication set up from 2000 to 05. Is there a
way to not let the snapshot agent to drop and recreate the destination
tables, but rather truncate them?
Thank you,
Igor
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Is there another way out? Posted by sql_er at 12/12/2006 12:10:22 PM Guys,
We have a transactional replication set up with a single publisher and
a single subscriber.
Recently, replication failed due to the following reason:
Data, erroneously, was deleted from subscriber. Then, to make the
publisher and subscriber synch, the same data was deleted from
pub...more >>
SQL Server 2000 merge replication: vanishing records Posted by WombatDeath NO[at]SPAM gmail.com at 12/12/2006 8:41:09 AM Hi,
I have a fairly major problem with my SQL Server 2000 merge replication
setup. Certain of my subscribers are causing conflicts such as:
"The row was inserted at 'MyServer.MyPublication' but could not be
inserted at 'Subscriber.Subscription'. Procedure or function
sp_ins_A7E27E390276442...more >>
Sql2K Merge Replication Remote Agent Activation Error 1011 Posted by Khooseeraj Moloye at 12/12/2006 12:00:00 AM In my customer's setup we have 1 publisher and 45 subscribers, with 6
publications. One server gets full data using a straight Push subscription.
All other servers receive full data for some publications and filtered data
for the other publications using HostName as the filter. To achieve this...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |