Insert and Update Procedures

[sturner333]

I have 2 stored procedures tied to a dataset in vb 2008 for updating and inserting info in a datagrid. The Update works, insert does not. Error:
Conversion failed when converting the varchar value '2009-11-02
00:00:00 ' to data type bit.

ALTER PROCEDURE dbo.InsertTimeLog
(
@id [int],
@dateEntered [smalldatetime] = '2/2/2000'
)
AS
Begin
INSERT INTO [dbo].[TimeLogEntered]
VALUES (       @id,
                      CONVERT(char, @dateEntered, 120))
end

@dateEntered gets a Use CONVERT error

[ck9663]

Check the structure of your table, relative to the value you're trying to insert.

-- CK