Viewing 15 posts - 46 through 60 (of 166 total)
How about just doing triggers. Also you may want to look at some transaction log reader options if you want to see 'before' data.
December 17, 2010 at 1:02 pm
Had one years ago from a third party vendor <cough>'CommerceOne'</cough> that was almost that long but it had a bunch of subqueries (about 40 or so if I recall)....
August 30, 2010 at 8:59 am
It might also be alphabetical location between the two. Suffice to say SQL Server does not translate.
August 24, 2010 at 12:51 pm
No, unicode does not convert to something simpler, so the pictograph for Godzilla does not move down to become the letter A.
You can do a bit of that sort of...
August 24, 2010 at 12:39 pm
If I am understanding question #1 correctly, you are asking if what is entered for a string has an impact on the collation used. No, it does not the...
August 24, 2010 at 8:15 am
A kill can have block implications outside of the realm they are aware of.
Depending on the nature of how connections are made there is a risk you may kill something...
August 24, 2010 at 8:08 am
Yes I have and my answer at the time was no...
You could look at offering it if they are using a read only connection or something, but yeah the rollback...
August 23, 2010 at 9:54 am
Is the first column a primary key? If so you could just do an update...
August 23, 2010 at 9:47 am
You could add the indexes in after you are done initializing by putting them directly into the replicant database after data is loaded. We do that to speed up...
August 19, 2010 at 12:23 pm
Setting up replication for large objects can be fun...
Are you replicating indexes? You may want to try replicating without creating the indexes (it will force the primary key I...
August 19, 2010 at 11:48 am
So you would want 08/19/2010 13:15 to show up as 08/19/2010 13:00 ?
August 19, 2010 at 11:30 am
I think the batch size setting only applies to replicated transactions not the initialization....
August 19, 2010 at 11:27 am
I don't think you can really do anything about the batch size with merge replication
August 18, 2010 at 1:56 pm
Have you considered setting the recovery mode on the target to simple?
August 18, 2010 at 12:51 pm
When you say 'database' is this Linux process even trying to connect to SQL Server or is it just putting files in a folder?
August 18, 2010 at 12:50 pm
Viewing 15 posts - 46 through 60 (of 166 total)