Viewing 8 posts - 1 through 8 (of 8 total)
Hi Dinakar,
Fantastic The sp generated perfectly, and more importantly, the table replicated perfectly. Interestingly, the resultant SQL is utterly different to the original.
However,...
August 22, 2006 at 6:09 pm
Thanks Dinakar,
I'm alright for the first 5 steps, but fail abysmally on the 6th
If I understand you, I need to run the generated...
August 21, 2006 at 2:39 pm
Oh well. Thanks for all your efforts, John.
This feature does seem peculiar I'll comment it out (luckily there are only 3 tables involved...
August 21, 2006 at 9:44 am
Thanks John.
1. I'll experiment with that. It looks like a good thing to try. Thanks
2. In my original post I made the point...
August 21, 2006 at 8:26 am
Thanks John,
Andrew
1. The terms "primary key" and "index" are not synonymous. A primary key is a constraint on a column or group of columns such that the...
August 21, 2006 at 7:42 am
I found this microsoft link very useful for setting it all up: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog03.mspx and this one for tuning: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx
Andrew
August 21, 2006 at 4:05 am
I've been playing with Transactional Replication, and the Microsoft article: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog03.mspx is very useful for these scripts.
To list tables with timestamp columns:
select o.name from sysobjects o
where o.type = 'U' and...
August 21, 2006 at 3:57 am
Thanks Steve. That view is perfect
Perhaps a future release of RS may allow us to use the Subscription Description as the SQLAgent Job...
January 28, 2006 at 1:56 pm
Viewing 8 posts - 1 through 8 (of 8 total)