Welcome to weblogs.com.pk Sign in | Join | Help

Knowing current SPROC name

Instrumentation though usually a "non-functional requirement"; but its considered to be critical especially in "enterprise class application". For this we usually need to know what is the current part of code being executing; against which we can log some info. Same applies to data-tier; thankfully TSQL has required functionaliy. This is how we can know the current SPROC name.

And yes; I am still using SQL 2000's Query Analyzer, its much faster than SQL Management Studio!

Published Thursday, November 2, 2006 7:39 PM by khurram
Filed under: ,


No Comments

New Comments to this post are disabled