Hi,

I have a 8 bit datetime field in a SQL Server 7.0 database. What I am trying to do is use a stored procedure to update the field. Here is the sp:

CREATE PROCEDURE [sp_update_UserLeagueDraft]
(@ID [int],
@NextPick [int],
@Round [int],
@Deadline [datetime])

AS UPDATE [deadlystrikecom].[dbo].[UserLeagues]

SET [NextPick] = @NextPick,
[Round] = @Round,
[PickDeadline] = @Deadline
WHERE
( [ID] = @ID)
GO


Getting this error when the sp is run:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

[Microsoft][ODBC SQL Server Driver]Optional feature not implemented


The main problem I think is datetime field.