I need to debug sevaral stored procedures that are on a linked server. I see there is a way to do this using Visual Studio.
IThe Management Studio has a Debug menu, implying that debugging can be done. If so, how do you get the stored procedure in a window to debug. With Visual Studio, you ger a "step into" option when you right click on a stored procedure name. I don't see this in Management Studio.
How do I do this?