Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Using Visual Studio to debug application

Author  Topic 

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-10-23 : 05:23:38
I'm using Visual Studio for the first to debug an application that is starting to get large.

In the Server Explorer I can see the sprocs and functions I want to debug.

When I hover the mouse pointer over the main procedure and right-click, the pop-up menu gives me all the options you'd expect but not the option to "Step Into Stored Procedure".

Does an option need to be set somewhere?

Help much appreciated.

tm
Posting Yak Master

160 Posts

Posted - 2007-10-23 : 09:10:18
I think you need to open the stored procedure first.
Refer to artical by Chirs Rock .. http://www.sqlteam.com/tag/sql-server-stored-procedures >> Debugging Stored procedures in Visual Studio 2005.
Go to Top of Page

nmarks
Yak Posting Veteran

53 Posts

Posted - 2007-10-30 : 06:24:36
Got the answer to this one.

My machine (in work) had not been given a full Visual Studio installation, once fully installed the option popped up.

However, to use the option you need Windows Authentication not just merely to be the sa going through SQL authentication.
Go to Top of Page
   

- Advertisement -