I want to create a new stored procedure but I got this error:
00955. 00000 - "name is already used by an existing object"
The problem is I don't remember to have created an object with this name and, now, I would like to remove it (don't worry, it's not on my production database).
How can I find the type of this object in order to drop it correctly?