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

michael (michael.atherton@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/SQLServ...dbackID=124537
and cast your vote.

Add if you could add a comment that it would 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