Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Transact-SQL

Debugging pure T-SQ stored procedures

I understand that there has been some dscussion on the subject of debugging T-SQL stored procedures. Can you point me to this information? I am not interested in how to debug CLR stored procedures as that is well documented.

Thanks
Bill Zack

[260 byte] By [BillZack] at [2007-12-21]
«« Image-tag with source requiring username and password
»» Problem with COM objecto
# 1
You still have to use Visual Studio:
  1. Open VS
  2. In Server Explorer create a connection to your database
  3. Expand your connection
  4. Expand the Stored Procedures node
  5. Right click on your stored procedure and choose Step Into Stored Procedure
  6. Debug away to your hearts content

Niels

nielsb at 2007-9-10 > top of Msdn Tech,SQL Server,Transact-SQL...
# 2
I'm working with beta2 and sql05 (april ctp) on the same box. Until recently I had the 'step into' selection. After formatting and reinstalling, the option is missing. I am baffled. Any ideas on how to get it back?
JonM at 2007-9-10 > top of Msdn Tech,SQL Server,Transact-SQL...
# 3
Which sku of Visual Studio did you install? Debugging is available only in VS 2005 pro and above skus.

Thanks,
-Vineet.

VineetRao-Microsoft at 2007-9-10 > top of Msdn Tech,SQL Server,Transact-SQL...
# 4
ah hah! I just installed the beta2 cd from msdn. It doesnt say anywhere inside of VS what edition it is. However, in add/remove programs it says Standard Edition. I must've installed a different version originally. I wonder what edition is on the VS2005 beta2 team suite CD from MSDN.
JonM at 2007-9-10 > top of Msdn Tech,SQL Server,Transact-SQL...
# 5

We used to be able to "Step Into Stored Procedure" from within the Business Intelligence Studio, but are now getting the following error:

"Unable to start T-SQL Debugging. Could not attach to SQL Server process on '<server name>'. Click Help for more information."

After searching on Help, it yields no result.

Does anyone have an idea why this maybe happening? We were able to debug our stored procedures a week ago, but now nothing. :(

Thank you!!

KimT at 2007-9-10 > top of Msdn Tech,SQL Server,Transact-SQL...
SQL Server
Transact-SQL

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified