I figure there is someway to pull this out but I can't find it anywhere.  I
have a recursive stored procedure and I want to error out if it recurses
more than 10 times.  How can I pull out how deep in the call stack I am?  Is
this possible?  I know I could pass a parameter to the stored procedure and
keep incrementing it but I was hoping there was a better way.

Altman (NotGiven@SickOfSpam.com) writes:
There is a global variable (or function as Microsoft calls it these
days), @@nestlevel that holds this information. @@nestlevel is increased
by 1 for every scope you to descend to. For this reason, I would be hesitant
to use @@nestlevel, as the rules would change if your procedure was
wrapped into another procedure. Passing a parameter is probably better.

The max nesting level in SQL Server is 32, by the way.

with(updlock) - How many times on same table in single update?
Composing a date from date parts
Delete Query ?
transactions
Is there alternative to T-SQL USE <dbname> where <dbname> is varia