TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
dc
NA
663
0
debugging vb.net 2008
Sep 17 2010 10:39 AM
I want to debug a vb.net 2008 desktop application that connects to a sql server 2005 standard edition database. I want to be know how to 'step through' sql in a stored procedure. I am using Visual Studio.net 2008 professional version connecting to a sql server 2005 standard edition database. What I have tried has not worked to far.
What I have done is:
1. I set a break point on the first declare variable name. I do not put a breakpoint on the
'alter procedure name dbo.sp name'. I also put a breakpoint on the last line of the stored procedure.
2. I select each project file that can be executed, right click and get the context menu then select properties and then put a check mark in the enable sql debugging and enable unamanaged code debuggging.
3. In server explorer in the visual studio.net 2008 ide I do the following:
a. right click on the data base connection and pick allow sql/clr debugging.
b. I right click on the stored procedure that I want to execute and select 'step into procedure'. A list of parameters show up and I hit the ok button.
Can you tell me what is wrong? On the internet, I saw a reference forvsql server 2008 stating that I need to run the 'sp_sdidebug' extended stored procedure to control access to the stored procedure. Since I am running against sql server 2005, is there some other database stored procedure or setting I need to use?
Reply
Answers (
1
)
working with one to many relationship
HELP!how to generate a crystal report from gridview data???