Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    43

    Unanswered: SP cannot be dropped

    Hi,

    I am getting below error when I recompile the SP get_data.
    I am compiling the script which first drops the SP and recreates the SP. I am not able to find who is using this SP. I have closed all applications and quit the sql sessions.
    Please note I would be only user using this SP. For workaround I am renaming the SP and creating again. But I am not able find the root cause.

    Please someone let me know the solution.

    Thanks
    -Durga

    Msg 3702, Level 16, State 1:
    Server 'SYB_SRV1', Line 8:
    Cannot drop the procedure 'get_data' because it is currently in use.

  2. #2
    Join Date
    Feb 2007
    Location
    Chennai, TN
    Posts
    68
    Hi,
    u can check the below link. The problem for occurence of Error 3702 is listed in the link


    http://manuals.sybase.com/onlinebook...38273;pt=38808

  3. #3
    Join Date
    Aug 2003
    Posts
    43
    Thanks parangiri.

    Quote Originally Posted by parangiri
    Hi,
    u can check the below link. The problem for occurence of Error 3702 is listed in the link


    http://manuals.sybase.com/onlinebook...38273;pt=38808

Posting Permissions

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