Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    11

    Unanswered: How to mark a system stored procedure to a non-system SP?

    Hi,

    I need to know how I can mark a system stored procedure to a non-system
    stored procedure. I have to edit it and put it back as a system stored
    procedure.I know it is not recommended but I still want to do it for a
    test. The system stored procedure is called when a user logs in but I
    don't know exactly when.

    Please help,

    S

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    If you want to see when it is being called by a user login, then try turning on Profiler (7.0/2000), SQLTrace (6.x).
    MCDBA

Posting Permissions

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