Connecting Tech Pros Worldwide Help | Site Map

Accessing the call stack via TSQL

michael
Guest
 
Posts: n/a
#1: Sep 30 '08
Hi

I was wondering if anyone new how to access the call stack information
via TSQL

I'm currently in the process of migrating an application from Oracle
to Sql Server 2005

There is a long running batch process where we currently catch the
error and collect the information of the call stack and allow the
procedure to keep running. This is a technique that allows easier
debuging should problems occure for customers.

Is there a way in sql server to get the information from the call
stack?

cheers

Michael
Erland Sommarskog
Guest
 
Posts: n/a
#2: Sep 30 '08

re: Accessing the call stack via TSQL


michael (michael.atherton@gmail.com) writes:
Quote:
I was wondering if anyone new how to access the call stack information
via TSQL
>
I'm currently in the process of migrating an application from Oracle
to Sql Server 2005
>
There is a long running batch process where we currently catch the
error and collect the information of the call stack and allow the
procedure to keep running. This is a technique that allows easier
debuging should problems occure for customers.
>
Is there a way in sql server to get the information from the call
stack?
Nope. But I encourage you to go to
http://connect.microsoft.com/SQLServ...dbackID=124537
and cast your vote.

Add if you could add a comment that it would help Oracle migration that
would be even better.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Closed Thread