Here am giving the procedure for how to debug a stored procedure in sql server 2k8 by using visual studio 2k8
START VISUAL STUDIO>GO TO FILE>NEW>PROJECT
POP UP WINDOW WILL COME
ON THE LEFT SIDE IN PROJECT TYPE COLUMN SELECT DATABASE AND THEN CLICK OK
POP UP WINDOW WILL COME TO CONFIGURE THE DATABASE>>GO THROUGH IT
AFTER SUCCESSFUL CONNECTION , EXPAND THE SERVER EXPLORER AND YOU WILL SEE ALL THE OBJECTS OF THE DATABASE YOU SELECTED EARLIER.
RIGHT CLICK ON STORED PROCEDURE FOR WHICH YOU WANT TO DEBUG AND CLICK STEP INTO STORED PROCEDURE
THATS IT..............
START VISUAL STUDIO>GO TO FILE>NEW>PROJECT
POP UP WINDOW WILL COME
ON THE LEFT SIDE IN PROJECT TYPE COLUMN SELECT DATABASE AND THEN CLICK OK
POP UP WINDOW WILL COME TO CONFIGURE THE DATABASE>>GO THROUGH IT
AFTER SUCCESSFUL CONNECTION , EXPAND THE SERVER EXPLORER AND YOU WILL SEE ALL THE OBJECTS OF THE DATABASE YOU SELECTED EARLIER.
RIGHT CLICK ON STORED PROCEDURE FOR WHICH YOU WANT TO DEBUG AND CLICK STEP INTO STORED PROCEDURE
THATS IT..............
No comments:
Post a Comment