Accessing the call stack via TSQL

[michael]

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]

Re: Accessing the call stack via TSQL

michael (michael.athert on@gmail.com) writes:

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/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=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@sommarsk og.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