Unable to create stored procedure

I am trying to recreate an application using ASP.NET MVC.

I have the following query to create a stored procedure in the local DB.

CREATE PROCEDURE Sp_Pessenger
    @PessengerID int = NULL,
    @FullName varchar(50) = NULL,
    @DOB Date = NULL,
    @Cnic varchar(30) = NULL,
    @contact varchar(30) = NULL,
    @Email varchar(50) = NULL,
    @Password varchar(50) = NULL,
    @CityId int = NULL,
    @GenderId int = NULL,
    @FlightId int = NULL,
    @cPassword varchar(50) = NULL,
    @ID int = NULL OUTPUT
AS
    INSERT INTO tbl_pessengers 
    VALUES (@FullName, @DOB, @Cnic, @contact, @Email, 
            @Password, NULL, @FlightId, @CityId, @GenderId)

    SELECT @ID = IDENT_CURRENT('tbl_pessengers')

In my old application, this is working correctly but in the new application, when I try to run this query on the bottom bar it shows that the query is completed with errors.

But I cannot figure out what is the error.