'Debugging Query' for a long time...

  • Wayne nailed it. Don't hit the green arrow, despite how tempting it looks.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Alternatives to the Red Exclamation mark (which historically with MS has meant problems), use F5 or Alt-X.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • WayneS - Wednesday, April 14, 2010 2:08 PM

    In SSMS, are you pressing the Green Triangle, or the Red Exclamation Point?The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query. You want to do the Red Exclamation Point...;-)

     Thank you so much.
    Till now I have pressed Green Triangle.
    Thanks for your kind help.I messed with this for two days.
    once again Thank you.<3

  • WayneS - Wednesday, April 14, 2010 2:08 PM

    In SSMS, are you pressing the Green Triangle, or the Red Exclamation Point?The Green Triangle is to run in Debug mode, the Red Exclamation Point executes the query. You want to do the Red Exclamation Point...;-)

     Thank you so much.
    Till now I have pressed Green Triangle.
    Thanks for your kind help.I messed with this for two days.
    once again Thank you.<3

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply