Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 7,636 total)

  • RE: Database compatibility change 80 to 90

    AFAIK, the "compatibility level" is a syntax-only setting. That is, it only affects the T-SQL syntax recognized and implemented.

    There are a very few other areas and tools on SQL...

  • RE: Database Mail issue

    I would suggest using either a command line or GUI SMTP tool on your server ot cinfirm that you can connect to your mailrelay and send mail outside of SQL...

  • RE: SSIS 2005 and datetime issues with null value

    Could you post the code, please?

  • RE: SSIS and stored procedures

    sridevi sriraman (5/24/2009)


    Hello All,

    My SSIS package is calling a stored procedure. When I change my stored procedure and then execute the package, there is no change. SSIS is doing the...

  • RE: SQL money datatype

    This BOL article has the list of all of the currency symbols that SLQ Server allows.

    I say "allows" instead of "recognizes" because apparently it does not do anything...

  • RE: Are the posted questions getting worse?

    Paul White (5/24/2009)


    Lynn Pettis (5/24/2009)


    Paul White (5/23/2009)


    What is this "soccer" everyone keeps referring to? :laugh:

    Well, it is what the rest of the world calls football or futbol. Sorry, but...

  • RE: NATURAL JOIN

    Jeff Moden (5/23/2009)


    Heh... curiously enough, Microsoft and Oracle have two different descriptions of what a "natural" join is.

    http://support.microsoft.com/kb/136699

    [font="Arial Black"]The Equi-Join and Natural Join[/font]

    ...

    A natural join is one in which only...

  • RE: Query Elapsed Time

    Florian Reischl (5/23/2009)


    ...For batch processing you need to query "sys.dm_exec_sessions" instead of "sys.dm_exec_requests".

    Could you explain that some more Florian? What kind of situation would you need to measure more...

  • RE: Query Elapsed Time

    Jeff: this is a typo, I think:

    Jeff Moden (5/23/2009)


    If so, then as Barry suggests, you have to measure it's performance over time and having the limit of 1/3rd of...

  • RE: Are you a Military Vet?

    bitbucket (5/23/2009)


    RBarryYoung (5/22/2009)


    bitbucket (5/22/2009)


    For those old enough to remember Korean Peace Keeping otherwise known as the Korean War

    !!!

    bitbucket, You're 75???

    Nope not 75 ... born April 1932 ... which...

  • RE: Are you a Military Vet?

    bitbucket (5/22/2009)


    For those old enough to remember Korean Peace Keeping otherwise known as the Korean War

    !!!

    bitbucket, You're 75???

  • RE: Append/ over write

    sam (5/22/2009)


    I want to know what happens when i append the recent backup file and when i overwrite the recent back up file? does both are same?

    "Append" means to attach...

  • RE: Are the posted questions getting worse?

    GilaMonster (5/22/2009)


    RBarryYoung (5/22/2009)


    That's Kevin Boles. He's a might be a bit dismissive at times, but he doesn't usually go off on someone like that. I'd suggest trying to...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/22/2009)


    No one is going to believe this, but a friend of mine & I were very minor characters in one of the Destroyer novels. We were introduced and...

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (5/22/2009)


    Gianluca Sartori (5/22/2009)


    Honestly, I would find paragraphs 2 and 3 quite offending if they were directed at me.

    I'm sorry, I don't know English well enough to...

Viewing 15 posts - 2,281 through 2,295 (of 7,636 total)