debugging SP or scalar function

  • Hi there,

    How can I set up my server to debug SP or function.

    I tried it in VS So I created connection on DB and when I choose SP, and clicked on it right mouse

    I dont see "step it over"

    I have Ms sql standart version ... its possible debug ?

    Thx Radek

  • I don't think Visual Studio will step through an SQL proc. Management Studio for SQL 2008 will do that, but I don't think VS will do it for 2005. I could be wrong, since I write all my queries in Management Studio.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Thx,

    So I have solving I installed other version of VS- professional, now its working.

Viewing 3 posts - 1 through 2 (of 2 total)

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