Solution USE [DB_Name] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_DeleteMember] @Id as bigint AS BEGIN SET NOCOUNT ON; Delete from Members_Table where ID = @Id END Explanation This delete stored procedure will delete the member from Members_Table whose member id is passed.