Viewing 15 posts - 1,981 through 1,995 (of 6,216 total)
You can't truly add a user to a database without adding the login first (note, you can, but then it's orphaned and you'd have to fix it, so just dont)....
June 29, 2003 at 4:27 pm
Could be something went wrong with cached data, I don't think its necessarily a bad drive, though a chkdsk is in order. Have you run dbcc yet? Might want to...
June 28, 2003 at 8:08 pm
Try running agent under a domain account instead.
Andy
June 28, 2003 at 8:06 pm
Probably need to consult with the tape drive manufacturer. Most of us prefer to backup to disk and from there to tape, that way if the tape backup fails, you...
June 28, 2003 at 4:55 pm
Slowing down...how slow? You could look at building a cube, might be overkill. I wouldnt consider 2 mil rows a lot. What size server?
Andy
June 27, 2003 at 9:09 pm
I've never seen a good reason either. I always force the recovery mode after each restart. Why give up the benefit of being able to do a point in time...
June 27, 2003 at 9:07 pm
As far as inserting multiple records, there are at least three ways to do it:
1 - Do what you're doing, execute one insert query for each record
2 - Build up...
June 27, 2003 at 9:04 pm
You either have to grant the NT user permission, or set up a sql login that has permission. Not great options. Only other way is to put the requests into...
June 27, 2003 at 12:39 pm
Unless you can return it as output parameters.
Andy
June 27, 2003 at 12:35 pm
Depends on the transaction size. I get decent performance over a fractional T1 (256k I think). Part of the reason I do replication over a WAN is that I dont...
June 27, 2003 at 12:33 pm
Code should work about the same. Hmm...well, maybe. As I recall it takes a little more work in Access to run a proc, I think a pass through is required....
June 26, 2003 at 6:10 pm
It should return a trappable error. You're giving the user more power than I would. An alternative way to do this is to run a proc that sticks a row...
June 26, 2003 at 6:08 pm
I'd be interested to hear. Doubletake (have not tried it either) does replication at the disk block level, might work for you.
Andy
June 26, 2003 at 6:05 pm
There is a check box when you add the subscription to start the snapshot immediately, really it just runs the job for you.
Andy
June 26, 2003 at 6:04 pm
DTS will do it pretty easily. I'd make sure you that you all the constraints and indexes, not just the tables. Probably are there, doesnt hurt to check. Might do...
June 26, 2003 at 6:02 pm
Viewing 15 posts - 1,981 through 1,995 (of 6,216 total)