|
|
|
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 invalud column name error in merge replication Posted by Darin at 10/31/2007 10:34:54 PM i have done merge replication on this machine many times. This time
(like other tiems) i completely removed and disabled replication on the
publisher/distributor using EM, and deleted replication on the
subscriber using sp_removedbreplication.
I recreated replication and when i do the push new...more >>
Remote Distributor: how to set one up? Posted by bourgon NO[at]SPAM gmail.com at 10/31/2007 9:57:51 PM I currently have replication running on SQL Server 2005, SP2. I want
to use a remote distributor. Is there any feasible way to move my
publications to use this new distributor, or instructions on doing
so? Or do I set up the distributor, then recreate replications,
telling them to use that on...more >>
Seemingly Simple Replication Question with SQL2K? Posted by sjwoo at 10/31/2007 4:02:21 PM I've been playing with replication for the first time today, and I
almost got it all to work...except I'm running into what must be
common problems:
1) Let's say I have three views, named:
vw_view1
vw_view2
vw_view3
Let's say vw_view1 references view2, i.e.,
SELECT *
FROM view2
S...more >>
Transactional Replication questions Posted by Ron at 10/31/2007 2:14:01 PM SQL2005 sp1
Once transactional replication is set up and running,
Will changing a table's structure (new column or new or changed SP) be
carried over to the replicated database?
Will it result in a replication failure and cause replication to stop?
Does a snapshot automatically run ...more >>
sp_helpsubscription_properties Posted by Brian at 10/31/2007 10:19:36 AM Hello,
I'm fairly new to SQL commands so if I'm posting this in the wrong
location, please let me know. When I run
sp_helpsubscription_properties from a former subscriber, I am
receiving two rows of publisher data. How do I delete these entries?
I've tried drop_server but that just gets rid...more >>
Invalid Object name 208 Posted by Pete Vickers at 10/31/2007 12:00:00 AM Hi,
when trying to replicate, after adding a new table, then i am getting the
error "Invalid object name 'dbo.sp_recreate_cybertill_tables'. (Source:
MSSQLServer, Error number: 208)"
This stored procedure no longer exists, but I can't get past this error. I
have tried a re-initialize, bu...more >>
Adding a primary key to a subscribed SQL 2000 table Posted by databaseninja at 10/30/2007 6:25:37 PM Hello,
We've got a very large production database with transactional
replication between two SQl 2000 servers. We would like to set up
sequential (cascading) replication between the current subscriber and
a 3rd server... running SQL 2005.
The problem we have is that it turns out we do not...more >>
bi-directional transactional replication for high-availability Posted by gigel at 10/30/2007 3:58:52 PM Hello all,
I am looking into setting up a bi-directional transactional replication
environment
as a high-availability solution.
Is this a practical solution?
Could I easily fail-over and fail-back? Manually won't be a problem.
I need to be able to pull out the publisher or subscriber for ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Job Failure Notification Posted by Ron at 10/30/2007 12:14:00 PM Using SQL2005 SP1 transactional replication to a reporting server.
I'd like to be alerted when replicaton stops for whatever reason. Is it
best to be notified via Database Mail for specific replication jobs. There
seems to 9 replication jobs alone on the publisher/distributor server. Whi...more >>
Problem Applying Schema Changes to Existing Merge Publication Posted by Crash at 10/30/2007 11:09:56 AM
Publisher:
- Windows 2000 SP4
- SQL Server 2005
Subscriber:
- Tablet XP SP2
- SQLExpress SP1
- Merge Pull subscriptions with parameterized filters
All,
As brief as I can:
We have 2 table articles and a trigger in our publication. The 2
tables, Table A and Table B, have...more >>
Problem With Replication On Port 2433 Posted by shgzs33 NO[at]SPAM gmail.com at 10/30/2007 8:44:52 AM I have 2 SQL 2005 Servers SERVER1 and SERVER2 and want to establish a
replication betwwen them: SERVER1 as Publisher and SERVER2 as
subscriber.
the problem is that SERVER2 is runnint on port 2433 and -I dont know
why- I cannot switch it to port 1433.
When trying to push a new subscription o...more >>
Log Shipping Performance Posted by Josh O'Brien at 10/30/2007 5:37:10 AM We here at $SOFTWARE_VENDOR are putting some numbers to various
reporting database scenarios, one of which includes log shipping. How
long does it take to replay a log on a target database? What are the
influencing variables? It will be something like a 100MB log replaying
on a $10k dedicated MS...more >>
Distributor Agent Posted by Michael Haskell at 10/30/2007 3:35:01 AM Using transactionl replication to replicate data to our reporting server.
The distributor agent is running on the subscriber. Concerned that if for
some reason the distributor agent is down or out of service replication
changes to the live data will not be replicated to the reports database....more >>
Is there any way to just find the new article added? Posted by SBR at 10/29/2007 6:40:03 AM Hi,
I'm adding a new table into a DB which is published already.
At present I'm looping through all the tables and finding it whether the
table has added for publication, and if not enable it for publishing.
But the number of article size is large. So it leads to a performance issue.
Is...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |