Viewing 15 posts - 1,441 through 1,455 (of 6,216 total)
Might be a nice open source project. Or an existing vendor might try it? Or an enterprising SQL person out there?
Andy
October 27, 2003 at 5:36 am
Have you checked all delimiters? Pipe, tab, etc? What about export to a csv, does that always work?
Andy
October 27, 2003 at 4:17 am
I don't do any Access development, but we do use it (at work, not here) for data management and the linked tables work well for the most part. Not always,...
October 27, 2003 at 4:16 am
I thought this one would be a little controversial! I think the security risks should be very heavily considered. That said, it did put forth an interesting idea and we...
October 27, 2003 at 4:14 am
I concur that we need to remain civil. Overall both this article and the original have evoked a good deal of discussion - good discussion! I'd hope that each might...
October 27, 2003 at 4:11 am
Very cool. Delivery times seem to vary quite a bit, guess it depends on how the timing works on to get it on the boat going over.
Andy
October 18, 2003 at 7:46 am
Thats one way. Another would be to return an output parameter from each proc that had the count.
Andy
October 17, 2003 at 6:56 am
Could also look at sysdepends, though its not 100%. You could also potentially have cross database references. You could run profiler for a day or two, build a list of...
October 17, 2003 at 6:54 am
October 17, 2003 at 4:12 am
Seems like it should be possible to make sp_MSForEachTable work. Not that there is anything wrong with what Gary suggests.
Andy
October 17, 2003 at 4:10 am
I hear you! (Unless the rate of usage increases...)
Andy
October 17, 2003 at 4:08 am
Not sure I follow, but seems like simple locking. An earlier step is creating the file and hasnt released it when the later step goes to use it. If slightly...
October 17, 2003 at 4:04 am
Sorry guys, I will get someone to check on it today.
Andy
October 17, 2003 at 3:57 am
At that point you're at 17 bytes per ID compared to 16 for a GUID. Good alternative though. And I suppose that you could still possibly exhaust the range someday...!
Andy
October 16, 2003 at 7:19 am
Another way might be to change their role membership via a job. At the start of the window add them to the role that allows update, at the end of...
October 16, 2003 at 5:24 am
Viewing 15 posts - 1,441 through 1,455 (of 6,216 total)