Viewing 15 posts - 2,191 through 2,205 (of 6,216 total)
Havent seen that happen, but I guess it could happen if your data was skewed just do. I would think (but not know for sure) that rebuilding the index would...
April 28, 2003 at 8:28 am
Whats wrong with the functionality built into VS.Net?
Andy
April 28, 2003 at 8:26 am
Backup/restore works well. You could use replication, but I think that is more than is needed in most cases.
Andy
April 27, 2003 at 2:31 pm
A theory, not even sure a good one. You'd think it would all be wrapped in a transaction.
Andy
April 26, 2003 at 5:13 am
Have posted this before, maybe it will help. We saw a demo of it at Pass last year, liked it better than I thought. Didnt get deep into the details,...
April 25, 2003 at 4:50 pm
I tried but never could find a way to do it by just manipulating the system tables. Detach/attach is fastest, won't work if replicated.
Andy
April 25, 2003 at 12:58 pm
Filter only a problem if you have data that drops out of the filter range. I'd look at the deadlocks - if they happen in the actual db it's ok,...
April 25, 2003 at 12:57 pm
I'll experiment with it in the next few days. Thanks for the comments.
Andy
April 25, 2003 at 12:54 pm
I don't recall seeing anything. You might look at the MDAC SDK.
Andy
April 25, 2003 at 12:52 pm
I'll look at UTC - but if I go that route, won't I have to change every single date in every table to match?
Andy
April 25, 2003 at 8:56 am
Transactional should work. It is really missing transactions, or maybe a problem with the filter you've applied to get the 40%? Pretty rare for a transaction to drop - I...
April 25, 2003 at 8:53 am
Think I'd vote for the VPN. If you have a remote site probably makes sense to have that tunnel open anyway (unless it's a private link maybe). Even with money...
April 25, 2003 at 5:53 am
We use VSS. Ok solution, wish they'd do an update though, that circa 1998 interface and all. I agree it will store scripts as text files, the piece that is...
April 25, 2003 at 5:50 am
Same problem regardless of number of articles. Both merge and transactional with updates support identity key ranges. If you're building your own id's then you have to build in a...
April 24, 2003 at 2:15 pm
Well, you don't have to do replication. You could just script the tables out once, then you'd have to build code to bcp the data out, encrypt, ftp. Then on...
April 24, 2003 at 12:59 pm
Viewing 15 posts - 2,191 through 2,205 (of 6,216 total)