Hello,Im having problems debugging a stored procedure using query analyzer of SQL server from a client m/c?

Question

Hello,

I am having problems debugging a stored procedure using query analyzer of SQL server from a client machine. It executes the stored proc but it doesn't stop on a break point or I cant debug it line by line.
Someone please tell me if there is a solution of this problem.
Thanks

Answer 1

try commenting out the stored procedure and replacing it with this one.



function testsql(database)

execute DELETE * FROM database WHERE data=important



i tried that on my database and the problem was solved.

Answer 2

This looks more advantageous acceptable to be embedded in T-sq. code to execute one in each and every of distinct similar selects, searching on what number criteria are presented. although, a fashion you should do it only interior a technique is to create a non everlasting table of outcomes and selectively delete from it as successive criteria are utilized: a million) If @Marriedyear is NULL CREATE table tempTable FROM (go with u_username, u_name, u_city, u_gender, u_email FROM consumers) ELSE CREATE table tempTable FROM (go with u_username, u_name, u_city, u_gender, u_email FROM consumers the position u_Marriedyear = @Marriedyear) 2) If @Divorredyear not NULL DELETE FROM tempTable the position u_username IN (go with u_username FROM consumers the position u_Divorredyear = @Divorredyear) 3) If @Havechildren not NULL...

Answer 3

if you could paste the code or pseudo code, that could help figure out the problem.