Connecting Tech Pros Worldwide Help | Site Map

Accessing the call stack via TSQL

  #1  
Old September 30th, 2008, 09:25 AM
michael
Guest
 
Posts: n/a
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
  #2  
Old September 30th, 2008, 11:05 PM
Erland Sommarskog
Guest
 
Posts: n/a

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