The Step Into Stored Procedure option is missing when I right click on a stored procedure in Visual Studio 2005. We are running SQL 2005 Workgroup Edition. I am working directly on the server running both SQL and VS and signed on as Administrator. Administrator is a DBO of the database.
I have found information on this issue being related to security rights and the remote debugger. I do not have RDBGSETUP.EXE.
Do I need remote debugging to debug directly on the server or do I need more rights than dbo or is this something else.