sql server - Deleting a stored procedure in the database -

While examining temptation (and then deleting), I'm using the same format on it:

  If object_id ('my_sp', 'U') is not a tap drop process enter my_sp process as dbo.my_sp (@ kwori varchar (100), @ search varchar (100)) [ Table] (Considering the examples of MSDN, this approach should work I / O>  

However, this is not:

first in the database Is a 'my_sp' item from itself.

An alternative approach would be something like

  from SELECTs OBJECT_NAME (my_sp) to sys.sql_modules as defined by '%' + 'mySP' + '%'  < / Div> 
 
 
  in the  object_id ('my_sp', 'u')  Specifies that the name is a  user table , for a process  or P  Use:  object_id ( 'my_sp', 'p')