Przytula,
I am able to build SQL procedures sucessfully.If I click the DUBUG button it is building the SP in debug mode and immediately executes the procedure and getting the result.It is not at all going into DEBUG state and also not stopping at the break points.
My doubt is:
Whether we need to set any parameters explicitly for SQL Stored procs??
Thanks,
Nagaraj