Forum Replies Created

Viewing 15 posts - 8,386 through 8,400 (of 19,564 total)

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    There are good reasons that it comes disabled by default.

  • RE: Uninstall SQL Server 2008 SSIS Service

    Have you tried to uninstall via add/remove programs or SQL Setup?

    Do you get an error message?

  • RE: Are the posted questions getting worse?

    How are things going for the All Blacks and SpringBok?

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/5/2011)


    Steve Jones - SSC Editor (10/5/2011)


    instance time v os time? Sheesh, is there a technical discussion taking place again?

    Perhaps, but it is in the guise of a smartass...

  • RE: Create Stored Procedure - can't end it

    As Remi did, a little indentation (formatting) goes a long way to helping resolve little problems like what you were experiencing.

  • RE: Are the posted questions getting worse?

    GilaMonster (10/5/2011)


    You get a difference because the query adds the milliseconds since the computer started to the time that SQL started. So if SQL Server started 27 seconds after the...

  • RE: Are the posted questions getting worse?

    SQL Kiwi (10/5/2011)


    SQLRNNR (10/5/2011)


    2 of 3 servers I get arithmetic overflow and the 3rd server differs by 35 seconds.

    Yeah great, so do I come back for the second interview or...

  • RE: Are the posted questions getting worse?

    SQL Kiwi (10/5/2011)


    Jan Van der Eecken (10/5/2011)


    Cool, but when I run this and also select GETDATE() on one of my servers, the two returned values differ by about 27 seconds....

  • RE: Syntax Error

    bkubicek (10/5/2011)


    JimS-Indy (10/5/2011)


    I just can't identify the syntax error in the last line here (WHERE clause) Can anyone help?

    INSERT INTO tblBoMDetail

    (BoMID,

    BoMItemDescription,

    BoMEItemQty,

    BoMEItemfactor,

    BoMEItemUOM,

    BoMItemUnitMaterialCost,

    BoMItemUnitLaborHrs,

    BoMlaborComplexity,

    BoMvendorName,

    BoMvendorPartNbr,

    BoMItemID)...

  • RE: Syntax Error

    Rather than a select * in each of the subqueries, identify the specific columns and make sure the columns are aliased appropriately if necessary.

  • RE: Today's Random Word!

    crookj (10/5/2011)


    SQLRNNR (10/5/2011)


    crookj (10/5/2011)


    SQLRNNR (10/5/2011)


    crookj (10/5/2011)


    bopeavy (10/5/2011)


    Exhausted

    Pooped

    return it to the neighbors

    "Aren't ya glad we didn't step in it?"

    No-Prize for guessing the source....

    Smells like

    Looks Like

    Tastes like

    And we have a winner!

    Beach and...

  • RE: Today's Random Word!

    crookj (10/5/2011)


    SQLRNNR (10/5/2011)


    crookj (10/5/2011)


    bopeavy (10/5/2011)


    Exhausted

    Pooped

    return it to the neighbors

    "Aren't ya glad we didn't step in it?"

    No-Prize for guessing the source....

    Smells like

    Looks Like

    Tastes like

  • RE: Today's Random Word!

    crookj (10/5/2011)


    bopeavy (10/5/2011)


    Exhausted

    Pooped

    return it to the neighbors

  • RE: How to verify the VLF is active or inactive?

    Perry Whittle (10/5/2011)


    SQLRNNR (10/4/2011)


    For more info check the links in my sig for Kimberly Tripp.

    Hmm, it is a good article, although I don't agree with Kimberleys statement that detaching a...

  • RE: Are the posted questions getting worse?

    Chad Crawford (10/5/2011)


    Stefan Krzywicki (10/5/2011)


    Jeff Moden (10/5/2011)


    Ninja's_RGR'us (10/5/2011)


    Jeff Moden (10/4/2011)


    GilaMonster (10/4/2011)


    Jeff Moden (10/4/2011)


    I wonder how many of us there are that try to completely ignore certs and degrees in...

Viewing 15 posts - 8,386 through 8,400 (of 19,564 total)