Viewing 15 posts - 2,161 through 2,175 (of 6,216 total)
Not an answer, but I think you're doing more work than you need to. If a pub gets out of sync all you need to is reinialize it, then re-run...
May 5, 2003 at 4:06 pm
Not all dll's require registration. Which files are you installing to support DMO operations?
Andy
May 3, 2003 at 5:11 am
I think the fact that it's canned and predictable. Walk into any company in the world, see maintenance plans, you know what's going on. No plans, then you have to...
May 2, 2003 at 1:34 pm
I much prefer passing XML, nicer format, lots of flexibility.
Andy
May 2, 2003 at 11:46 am
You can set a query timeout, either on the server or on the command/connection running the query. Not the best, but sometimes better than nothing. For long running processes locks...
May 2, 2003 at 11:45 am
I have Franciso Balena's book (www.vb2themax.com) for .Net, truly useful book, includes an e-version of his VB6 which was also very good. Haven't tried any of the CD's.
Andy
May 2, 2003 at 11:42 am
Im surprised there is such a big disparity between backup vs bcp, maybe I just never looked. One idea is to break it up into separate publications, maybe separate pub...
May 2, 2003 at 11:41 am
Something close to this:
char(asc(right(colname,1))+1)
Andy
May 1, 2003 at 4:01 pm
May 1, 2003 at 4:27 am
I'll put a simple one together for next week, we'll see what happens.
Andy
April 30, 2003 at 1:08 pm
Exactly. With an outer join where you're looking for the missing records, you need to put all the other criteria in the join, just check for null in the where.
Andy
April 30, 2003 at 8:16 am
How much free space on the other machine? 5g file should not be a problem, could be that the free space calculation is blowing up if there is 'too much'...
April 30, 2003 at 8:14 am
April 30, 2003 at 6:35 am
I dont see the limit referenced in that link?
Andy
April 30, 2003 at 6:33 am
That's not bad. Didn't I see one of those in the last couple days? Something where you used a cross join to solve it?
Andy
April 30, 2003 at 6:30 am
Viewing 15 posts - 2,161 through 2,175 (of 6,216 total)