Forum Replies Created

Viewing 15 posts - 346 through 360 (of 458 total)

  • RE: Connection to SQL Server dropping

    Brandie Tarvin (11/28/2012)

    The error you posted doesn't look like a timed out connection, just a failed connection. That tells me that no connection was actually made. However, I'm not looking...

    November 28, 2012 at 12:47 pm

    #1563404

  • RE: Connection to SQL Server dropping

    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 🙂

    I...

    November 28, 2012 at 10:11 am

    #1563301

  • RE: Connection to SQL Server dropping

    Lowell (11/28/2012)

    search the code and see if there is a {MyConnection}.Close, where {MyConnection} is the variable name for your Connection...it might be being closed when you don't expect it to...

    Nope....

    November 28, 2012 at 10:04 am

    #1563293

  • RE: Connection to SQL Server dropping

    bleroy (11/28/2012)

    Have a look in the windows event log (http://support.microsoft.com/kb/308427), a number of categories there, check them all out (although Application log should be the most relevant), the right panel...

    November 28, 2012 at 9:46 am

    #1563271

  • RE: Connection to SQL Server dropping

    bleroy (11/28/2012)

    Not knowing what OS we are talking about, I will assume that the machine runs with Windows Server 2003+.

    My apologies - Alzheimer's working overtime today. It's Windows Server Standard,...

    November 28, 2012 at 8:13 am

    #1563183

  • RE: Connection to SQL Server dropping

    Brandie Tarvin (11/28/2012)

    Do you have Auto_Close enabled on your SQL Server properties?

    I do not. I'm looking at it right now. AutoCreate and AutoUpdate Statistics are both true, AutoClose, AutoShrink and...

    November 28, 2012 at 7:33 am

    #1563147

  • RE: Connection to SQL Server dropping

    bleroy (11/28/2012)

    Hi,

    Do you have access to the machine hosting the SQL Server DB? if so, can you check on there for the windows log, and sql serror logs?

    See if there...

    November 28, 2012 at 7:15 am

    #1563135

  • RE: LIKE with and without wildcards in WHERE clause

    GSquared (11/27/2012)

    pdanes (11/27/2012)

    There doesn't seem to be any clear consensus on all this, so I guess I'll have to build a bunch of test cases and see what comes of...

    November 27, 2012 at 4:09 pm

    #1562882

  • RE: LIKE with and without wildcards in WHERE clause

    There doesn't seem to be any clear consensus on all this, so I guess I'll have to build a bunch of test cases and see what comes of it. Still...

    November 27, 2012 at 9:34 am

    #1562749

  • RE: LIKE with and without wildcards in WHERE clause

    sjimmo (11/27/2012)

    Have you considered a full text index? I have had very good luck in some cases with issues such as yours. Check it out here and see if it...

    November 27, 2012 at 9:27 am

    #1562748

  • RE: LIKE with and without wildcards in WHERE clause

    DiverKas (11/26/2012)

    But wouldn't this always compare all variables, though? In the syntax with OR, the query engine can see that a variable is empty, thereby satisfying one side of the...

    November 26, 2012 at 10:50 am

    #1562319

  • RE: LIKE with and without wildcards in WHERE clause

    Luis Cazares (11/23/2012)

    The easiest way is to do it like this

    WHERE Oink.[System] like @System + '%'

    ANDOink.Stratigrafie like @Stratigrafie + '%'

    ANDOink.Ulozeni like @Ulozeni + '%'

    AND Oink.DrEvid like @DrEvid + '%'

    Or you...

    November 24, 2012 at 6:36 am

    #1561975

  • RE: LIKE with and without wildcards in WHERE clause

    Luis Cazares (11/23/2012)

    I have two options for you.

    The first is to change the empty string for a '%', that way you get rid of the ORs. You need to do...

    November 23, 2012 at 1:57 pm

    #1561934

  • RE: LIKE with and without wildcards in WHERE clause

    Gazareth (11/23/2012)

    If speed isn't a issue here, I doubt it'd be worth it. I imagine there's easier ways to get bigger improvements too.

    Best bet would be to test for each...

    November 23, 2012 at 1:49 pm

    #1561932

  • RE: Automatic backup task

    Okay, it's running. I'm not quite sure exactly what finally did the trick - I played with modifying the access privileges, as one of the articles suggested, and I restarted...

    October 30, 2012 at 10:32 am

    #1554261

Viewing 15 posts - 346 through 360 (of 458 total)