cnjadhav wrote:
ALTER PROCEDURE [dbo].[Proc_Department_Select]
Change the word 'ALTER' to 'CREATE'!
Currently, the stored procedure doesn't exists in your database. First time you need to use CREATE. Once it is there, use ALTER on further edits if any.