|
|
|
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 Deadlock between Distribution Agent and Distribution Agent Cleanup Posted by Andrew Pike at 12/30/2005 3:19:02 PM This is occurring regularly on SQL Server 2000 build 878.
The problem is a deadlock in the Distribution database. The Distribution
Agent spid is executing the SELECT statement below:
select @max_xact_seqno = max(xact_seqno) from MSrepl_commands (READPAST)
where
publisher_d...more >>
Adding a table, stored procedure, or view in push tranaction repl Posted by Wingman at 12/30/2005 2:33:02 PM We are using SQL 2k and use push replication. If I want to add a table, a
view or a stored procedure to a publishing table, view or stored procedure,
can I just create them using EM or query analyzer manually in both the
publishing table or subscribing table without involving replication?
...more >>
how to tutorial for Replication Posted by Ten Ten at 12/30/2005 1:34:01 PM Hi ,
where can i find a goog tutorial for mssql server replication step by step ?
thanks for answers
...more >>
Change replicationAgent that starts SQLSERVERAGENT Posted by Wingman at 12/30/2005 8:07:02 AM Hi,
We are using Push subscription in our transactional replication setup in SQL
2K and I noticed that the SQLSERVERAGENT service is started by a local
account called replicationAgent. Is it a problem for me to change it to a
different local account? If it is ok to change it, do I need t...more >>
Help w/ Error 107: The column prefix 'FTL_UB_Customers' does not match with a table name or alias name used in the query. Posted by Ricky at 12/30/2005 7:13:38 AM I am desperately hoping that someone here can help me so that I can
stop my premature balding. I am running SQL Server 2000 on two servers
both running Windows 2000. I have a snapshot replication setup from
Server1 to Server2 where Server1 acts as the distributer and contains
the published dat...more >>
Transaction replication question Posted by SSM at 12/30/2005 6:54:03 AM My goal is to create a warm standby using transaction replication with
instantaneous updating to the subscriber. I only have two servers. Should I
place the distribution database on the same server as the publisher or the
subscriber? Is it even possible to place the distribution database on...more >>
"Select *" in Replication Tables Posted by SouRa at 12/29/2005 8:25:03 PM Hi,
I used "select * from replicate_table_name" in my stored procedures and my
application.Now i want to replicate that tables.
Will it affect my application and Replication.
Please Advice me.
Regds
Soura
...more >>
SQL2005 - Mirroring and TransLogShipping problem Posted by Jay Becker at 12/29/2005 12:42:04 PM Hello everyone. We are evaluating SQL 2005 Standard for both a mirroring and
log shipping scenario. We want to have database mirroring setup in house and
log shipping to a remote site. We have successfully implemented db mirroring
using the trace flag 1400, like this.....
sqlservr -d"c:\...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Filter clause Posted by marshallae NO[at]SPAM bowater.com at 12/29/2005 7:07:09 AM We are moving to SQL 2005 Standard Edition are use numerouse filters
for replication. In SQL 2000, we had a lot of the filters setup using
an OR statement in the filterclause (ie. a.company = b.company or
a.subcompany = b.company), and had no problems with adding the filters.
In SQL 2005, cre...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |