What, where, how, why is sp_sproc_columns used ?
Last night our users were getting blocked by "sys.sp_sproc_columns;1" from one of the user processes, but I don't understand what the root cause might be.
TIA
Printable View
What, where, how, why is sp_sproc_columns used ?
Last night our users were getting blocked by "sys.sp_sproc_columns;1" from one of the user processes, but I don't understand what the root cause might be.
TIA
Which rdbms do you use? This may give you something you are looking for: http://sqlserverpedia.com/wiki/Sp_sp...ored_Procedure