MSSQL - Check if stored procedure exists

Watch this example on YouTube:


IF EXISTS(Select * FROM sys.objects Where type = 'P' and name = 'NameOfYourStoredProcedure') print 'OK'