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.
| Author |
Topic |
|
sliddle
Starting Member
2 Posts |
 Posted - 2009-10-14 : 06:58:14
|
| I installed Visual Studio 2005 Professional Edition to be able to debug stored procs in my sql server 2005 db using the 'Step into Stored Procedure ' option.However, when I right click on the stored proc I only have the following options: Copy, Refresh, Properties.The options that are missing are:Add New Stored ProcedureOpenExecuteStep into stored procedureDeleteHow do I get the above options that are missing ?S. Liddle |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-14 : 08:13:02
|
| How are you connecting to the database? Windows authenication?What permissions does the account have to the stored proc? |
 |
|
|
sliddle
Starting Member
2 Posts |
Posted - 2009-10-14 : 08:41:57
|
| When I Add a db Connection in Visual Studio Server Explorer I specify an ODBC datasource which uses sql server authentication. The user I login as has the following server roles:dbcreatordiskadminprocessadminsecurityadminserveradminsetupadminsysadminS. Liddle |
|
|
|
|
|
|
Debug Stored Proc using Visual Studio