Hi Sergey,
Good references to explore, but unfortunatly not the problem. I can create the sp myself and still not be able to step though. Assuming the debugger actually works, I'll eventually uncover the problem. Thanks.
Gary
>>I'm trying to use the query analyser debugger. It looks good, but I can't step into the code, only execute it. The step in, out and over buttons are disabled. Has anyone else run into this? Thanks.
>
>Hi Gary,
>
>See if
BUG: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures with Same Name Owned by Non-DBO Users mskb #
296539 is relevant to your problem. Check also
INF: Transact-SQL Debugger Limitations and Troubleshooting Tips for SQL Server 2000 mskb #
280101