Viewing 15 posts - 3,826 through 3,840 (of 9,726 total)
So you can't find any events that indicate the SQL Server services shut down, recycled, or that a connection got dropped *before* you got the error posted in your OP?
And...
November 29, 2012 at 5:09 am
Hey, all. Anyone have any experience with MS Access applications (adps, etc.) that use SQL Server as a back end?
I have experience on the SQL side, but a lot of...
November 29, 2012 at 5:05 am
plsh (11/29/2012)
Thank you, that is what I was asking. So mixed mode works, that is all I was after.
Which is what I said in my initial reply. @=)
no disrespect but...
November 29, 2012 at 4:56 am
And now back to the non-technical portion of The Thread...
Has anyone had one of those days where you look at your inbox and you realize your entire day has been...
November 28, 2012 at 12:41 pm
Revenant (11/28/2012)
Brandie Tarvin (11/28/2012)
GilaMonster (11/28/2012)
Anyone with more patience than me want to try and handle this?http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx
Previous threads on the subject:
http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx
I'm going to do a horrible thing and ask a technical...
November 28, 2012 at 12:38 pm
GilaMonster (11/28/2012)
Anyone with more patience than me want to try and handle this?http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx
Previous threads on the subject:
http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx
I'm going to do a horrible thing and ask a technical question prompted by...
November 28, 2012 at 11:36 am
SQLSACT (11/28/2012)
Now, when that change gets reflected on disk, does the changed page in Memory replace the corresponding page on disk?
"replace" is a poor choice of words here. When...
November 28, 2012 at 11:22 am
pdanes, have you checked your connection pooling properties both in the app and on the server to make sure you can reuse existing connections and that the pool isn't throttled...
November 28, 2012 at 10:52 am
Bhuvnesh (11/28/2012)
WHat if we use SSIS to do this stuff more robust more tracable .. more comfortable to handle heavy volume data. i will welcome suggest on this suggest 🙂
If...
November 28, 2012 at 10:50 am
pdanes (11/28/2012)
Other options are to do a tracert and a ping from the location of this particular Access db to see if that machine can even hit the SQL server.
EDIT:...
November 28, 2012 at 10:47 am
Ditto to what Anthony said. Additionally, SQL authentication is usually managed locally or more freely than Windows authentication. This fact sometimes makes it easy for a guy to get sysadmin...
November 28, 2012 at 10:39 am
jcrawf02 (11/28/2012)
Grant Fritchey (11/27/2012)
jcrawf02 (11/27/2012)
Okay, so looking at the new ads from redgate on the site, and thinking Steve is obviously Hannibal, which makes Grant...Mr. T?
No, no, no. I am...
November 28, 2012 at 6:16 am
We need your table DDL (CREATE TABLE statements) and some sample data to test with, please.
November 28, 2012 at 6:03 am
ssarria (11/28/2012)
Hey Pavan,some how is not working, it is giving me an error messages. It is a syntax error... sorry I am still learning SQL..
Thanks!
S
Please post all your code and...
November 28, 2012 at 5:50 am
Actually, I have a few thoughts that could get around this. Mainly via the use of a subquery that selects each distinct property and then JOINs to the other tables...
November 28, 2012 at 5:48 am
Viewing 15 posts - 3,826 through 3,840 (of 9,726 total)