Results 1 to 2 of 2

Thread: sp_sproc_columns Blocking !?

  1. 10-24-2012, 09:41 AM #1
    homebrew
    homebrew is offline Registered User
    Join Date
    Oct 2002
    Posts
    21

    sp_sproc_columns Blocking !?

    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
    Reply With Quote Reply With Quote
  2. 10-25-2012, 08:05 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Which rdbms do you use? This may give you something you are looking for: http://sqlserverpedia.com/wiki/Sp_sp...ored_Procedure
    Last edited by rmiao; 10-25-2012 at 08:10 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules