Viewing 15 posts - 3,226 through 3,240 (of 5,685 total)
tfifield (5/5/2011)
I thought about that about 1 minute after I posted it and did the old Homer Simpson DOH! I then got a bunch of phone calls from clients...
May 5, 2011 at 2:21 pm
Nils Gustav Stråbø (5/5/2011)
Could it be that network latency causes ack messages to be delivered too...
May 5, 2011 at 11:53 am
^ What Howard said. Everyone's in public at all times. All deny's on SQL Server are exclusive Denies, they can't get overridden. Deny connect to public locks...
May 5, 2011 at 11:49 am
By chance do you have a timeout parameter set on your BEGIN CONVERSATION line?
Also, you mention you can't find the message in the queue, but by chance have you seen...
May 5, 2011 at 11:44 am
Stefan Krzywicki (5/5/2011)
Are you using agencies for this position? Is it contract or perm?
Yes and perm.
Regarding the exceptions: I currently have to make those often enough for medical reasons (dental),...
May 5, 2011 at 11:29 am
bimplebean (5/4/2011)
May 4, 2011 at 5:01 pm
Another choice, especially if they're all coming from the same source database, would be log shipping.
You CAN tell transactional to wait a while, but depending on volume you're going to...
May 4, 2011 at 4:59 pm
barry.a.seymour (5/4/2011)
Here's my situation: I have to refresh table data nightly; however I need to leave everything else (procedures, views, stored procedures) intact.
I personally would look into a transactional...
May 4, 2011 at 4:33 pm
Stefan Krzywicki (5/4/2011)
Craig Farrell (5/4/2011)
GSquared (5/4/2011)
Craig Farrell (5/3/2011)
May 4, 2011 at 4:19 pm
JMI (5/4/2011)
"Data access mode" in OLE DB Destination.
That's where the problem was!
As soon as i switched to fast load
it took only 2 min to load 3 half...
May 4, 2011 at 12:08 pm
That unfortunately is merely the column maps. We'd need to see connection information, what type of load is it doing (fast or not), is it table locking, what the...
May 4, 2011 at 11:47 am
Thanks very much for the google-fu'ing. I'll be over here reading... and getting my jaw back off the floor.
May 4, 2011 at 11:43 am
JMI (5/4/2011)
I am usingfor MS Access connection:
Native OLE DB/Microsoft Jet 4.0 OLE DB Provider
(the actual mdb file is Access 2000 version)
My first question here is how fast can you usually...
May 4, 2011 at 11:27 am
Hm, I almost NEVER qualify my table names with the schema names, particularly dbo.
This is a bit of an eye-opener for me. Can someone point me in the direction...
May 4, 2011 at 11:22 am
Viewing 15 posts - 3,226 through 3,240 (of 5,685 total)