Viewing 15 posts - 3,811 through 3,825 (of 9,707 total)
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
Just because SCCM requires windows authentication doesn't mean that you have to alter your SQL Server authentication settings. You just need to make sure security in the database is set...
November 28, 2012 at 5:45 am
Do you have Auto_Close enabled on your SQL Server properties?
That's the first thing I would check. If not, then I would get a network sniffer running while you try to...
November 28, 2012 at 5:41 am
Unless I'm misreading this, the buffer pool doesn't come from SQL Server's allocated memory.
BOL says
November 28, 2012 at 5:37 am
You can search stored procedure definitions by joining sys.objects to sql_modules and doing a WHERE clause with a LIKE statement on the definition column of sql_modules. That should locate all...
November 28, 2012 at 5:30 am
I don't use FULL TEXT, but this isn't the first time I've heard of this sort of issue. Could you post some DDL, sample data, and the querying code you've...
November 28, 2012 at 5:29 am
TealCanady (11/26/2012)
I don't know the alert code you're using ....
Teal, I attached the code I'm using as a text file to my first post in this thread. It's hitting the...
November 28, 2012 at 5:25 am
capnhector (11/26/2012)
November 28, 2012 at 5:21 am
Viewing 15 posts - 3,811 through 3,825 (of 9,707 total)