|
|
|
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 error 4819 Posted by Duncan at 6/30/2004 9:12:22 PM I have just created a snapshot manually and started the synch manualy and I
am getting :
error 4819 - Could not bulk insert. Bulk data stream was incorrectly
specified as sorted.
Anyone point me to why this might be happening? Its a severity 16, so user
caused and supposedly user fixable.
...more >>
Lost connection to subscriber, translog on pub is growing Posted by Combfilter at 6/30/2004 5:52:08 PM Is there a way to shrink the translog at the
pub if the subscriber is down for an
indefinite amount of time? Without deleting
the package and setting it back up again?
thx
-comb...more >>
Change the contraint on a published table Posted by Warren Patterson at 6/30/2004 5:45:14 PM Hi,
Is it possible to remove/change a constraint on a table that has been
published, without reinitilising the subscriber?
Setup:
Merge Replication
Subscribers initiate a pull subscription
Kind Regards
Warren Patterson
...more >>
Replication design Posted by Edgard Riba at 6/30/2004 3:16:29 PM Hi,
I'm new to MSSQL replication, and was hoping for some advice as to
recommended practices for my scenario.
I will have a 4 SQL server scenario at four locations connected through a
TCP/IP wan (i.e. each site is connected to the internet).
One of the sites is the headquarters site. S...more >>
Push over the Internet? Posted by Kyle at 6/30/2004 2:53:01 PM Is it possible to have a push subscription for merge replication over the Internet?
If so, how?
If not, does anybody know why not?...more >>
Recreate an expired/dropped subscription Posted by nate axtell at 6/30/2004 2:36:22 PM My setup is Merge Replication with Push subscriptions.
When a subscription expires it is deleted by the Expired Subscription Clean
Up Agent. What is the best way to recreate and initialize the subscription
to ensure that I get ALL the meta data changes that were made at the
subscriber?
I was...more >>
Log reader question Posted by Duncan at 6/30/2004 12:57:46 PM Hello,
I am using SQL Server 2000 and have a question about the log reader.
I have read, that you can schedule the log reader to run, for instance once
a day. My question is when does the log reader 'know' when to stop?
Thanks in advance,
Duncan.
...more >>
forcing an identity to be even\odd Posted by Svur at 6/30/2004 11:58:23 AM Hi
I am not able to implement even odd series, the tables
are generating autonumbers with 'last value + 2' for the
next value (inspite of saying identity seed is 2 and
increment is 2). thisway, if the last value on
a 'supposed' even table is turming odd if the last merged
value is odd. is...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Basic problems with replication Posted by urga at 6/30/2004 10:33:29 AM Hi
I've just installed Sql Server 7 and wanted to see how replication works.
With DTS i copied Northwind database so now i have two db Northwind and
Northwind_copy on my server.
Using wizards (default values) I've tried snapshot replication from
Northwind (publication) to Northwind_copy (pull...more >>
Replication design Posted by Shrikant Patil at 6/30/2004 8:59:09 AM Hi,
I have the following scenario, and need to configure
replication for this. Pls advice.
We have 3 SQL server databases, at 3 locations on SQL
server 2000 servers. They are connected over WAN by 2
MBPS link (triangle). I have to configure replication on
this. Database has around 200 ta...more >>
Should I be using replication? Posted by google NO[at]SPAM erb.com at 6/30/2004 7:53:05 AM Long description for short question:
I currently have a database application using Access 2003 as the front
end and as the back end. I will be changing the back end to SQL
Server 2000.
The front end links to 2 databases at any time. One of the databases
is the "collection" and the other dat...more >>
Sql LiteSpeed backup/restore frm 64 bit to 32 bit sql server.... Posted by Syed at 6/30/2004 12:39:01 AM Hi,
I am trying for the best and fastest method to do database backup restores between 64bit version of SQL Server and 32-bit. We are using SQLLITESPEED software but it gives software version issues while I am trying to restore backup in SLS format taken on 64 bit and trying to restore it on a 32...more >>
Replication over satelite connection. Posted by kjso at 6/30/2004 12:34:01 AM Hi everybody, we are designing an application for ships, and I want to replicate data between the ships and a home office. TCP/IP communication is not possible, but we have a e-mail based system for transferring files.
What is the best solution? Is it possible to have the publisher/subscriber to ...more >>
stored procedure custom resolver question Posted by news.microsoft.com at 6/29/2004 4:42:20 PM I've looked at the avgprice example for northwind but don't understand what
would happen if the conflict occured because of a delete. I'd like to
create a resolver that the subscriber always wins the update unless the row
was deleted at the publisher.
TIA
...more >>
Would this work for moving a server doing replication? Posted by Combfilter at 6/29/2004 4:39:58 PM
http://vyaskn.tripod.com/moving_sql_server.h
tm
I can see how it would work for just a sql
server, but a sql server doing replication
it might be harder to accomplish. Has
anyone here done this with a replication
box?
TIA,
-comb...more >>
Expired Subscription Posted by nate axtell at 6/29/2004 3:22:09 PM Does anyone know how to manually set a Subscription to be Expired? I'm not
looking for a hack, but if that is all you have I will try it. I was hoping
that there might be a system stored procedure that would do it, although I
know that is pretty doubtful. The reason for this is because now I h...more >>
transactional replication with TSQL - snapshot agent problem Posted by anonymous NO[at]SPAM discussions.microsoft.com at 6/29/2004 2:29:22 PM Hi
I am trying to setup transactional replication. when i
run the script it runs fine. but the snapshot agent is
not running. i can see that in
distribution..MSSnapshot_Agents table. but when i try to
run that in enterprise manager its giving me error
message that specified job not fou...more >>
merge replication, snap shot failure at publisher Posted by SVur at 6/29/2004 2:12:50 PM Hi,
The snapshot agent is failing with the following message.
The MDAC version that i can see is 2.71.XXXX. Rightnow, i
am having all the publisher/distributor/subscriber on the
same server.
Can somebody help?
Error:
The process could not bulk copy out of table '[XXXX].
[XXXXXXXXXXX]'.
...more >>
Pull Subscription Posted by scott NO[at]SPAM jucovics.com at 6/29/2004 12:47:05 PM I am setting up a pull subscription and I keep getting an error
message:
"SQL Server Enterprise Manger could not create a pull subscription to
publication 'XX'. Error 14053: Cannot load the DLL replincrementlsn
extended procedure, or one of the DLLs it references. ...."
Any suggestions on...more >>
Custom Conflict Resolution Question Posted by Gene S at 6/29/2004 11:37:36 AM Hello,
I have to setup custom conflict resolution so that the
most recent update wins using a column 'lasteditdate' in a
a merge replication scenario and have about 150 tables to
do this on. Do I have to configure each table/article
individually or can I do all necessary tables in one sh...more >>
Transactional replication - limited to 255 columns Posted by SqlJunkies User at 6/29/2004 10:55:24 AM Is there a fix for the SQL transactional replication where you can only have 255 columns in a table? The error message I'm getting is:
Error 20068: The article cannot be created on table <table name> because it has more than 255 columns.
What are the fixes for this?
Thanks!
---
Po...more >>
Merge replication over internet Posted by Kevin3NF at 6/29/2004 9:40:55 AM Good morning,
I am attempting to set up merge replication between a SQL Server on SBS2003
box (publisher and distributor) and a SQL Server 2000 box (subscriber) in a
different state (hosted, connect via IP addresses).
I can push the publication to the subscriber, but the synch process fails
...more >>
another sp_repladdcolumn option question Posted by djc at 6/29/2004 8:47:33 AM Syntax
sp_repladdcolumn [ @source_object = ] 'source_object'
, [ @column = ] 'column' ]
[ , [ @typetext = ] 'typetext' ]
[ , [ @publication_to_add = ] 'publication_to_add' ]
[ , [ @schema_change_script = ] 'schema_change_script' ]
[ , [ @force_invalidate_snapshot = ] force_...more >>
How can i do?( merge replication) Posted by lemonvital at 6/29/2004 12:47:14 AM I use merge replication between parent company and subsidiary
company.parent company is central subscriber.
I only want to merge when publisher insert and update data or subscriber
update data. I don't want to merge when publisher delete data or subscriber
insert and delete data. who can giv...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |