Can't Debug a Stored Procedure
I am trying to debug a stored procedure and I have not been able to do so. I have opened Visual Studio 2005 and created a connection to the database. I can see the procedure in the server explorer but when I right-click on the procedure the context menu does not have the "step into" option in it.
I have read through many help files online and they tell me to do the things that I have already done. None of them even discuss the scenario that is happening to me.
I have logged in to the SQL Server as myself and as SA neither allows me to debug. Another person in my office can connect to this same SQL Server using the same version of Visual Studio and has the option to debug.