Cannot Drop Stored Procedure

[Kal Pathak]

Hi folks,

I am using SQL Server 6.5. I try to drop a Stored Proc and I get the following Error Message "Error 3702: [SQL Server] Cannot Drop the Procedure 'xyz_sp' because it is currently in use."

There are no users in the Database and no process is using this stored procedure.

I have tried to drop this Stored Proc using the Enterprise Manager and throught ISQL_w. I get the same error.

Can anyone tell me why I am unable to drop this Stored Proc?

Thanks

[Antwort]

You shouild make sure that you are owner of the stored proc. Something like dbo.MyStoredProc or xy_user.MyStoredProc
Good luck

Antwort / www.immohit.ch

[rmiao]

Use 'sp_depends sp_name' to double check if any object references it.