'sp_active_processes'. error

  • I am trying to run 'sp_active_processes'. and keep getting an error msg 2812 saying it cant find the stored procedure

    I am running it from query analyzer. I have tried 2000, 2005 and 2008r2 with no luck.

    Can someone tell me what I am doing wrong?

  • This looks to be a stored procedure that you have downloaded or written. Are you trying to run it from the correct database?

    Does the procedure exist in the database you are using or on the instance at all?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply