One of the pages on my current project contains a simple status table that
shows whether an event has occurred or not. Currently it needs to be reset
to False at the start of each business day, then is manually flagged True
when the event occurs. The flag to True must remain manual because it is
never known when the event will happen. However it would be one less thing
to worry about when opening the store if it could be reset to False each
morning automatically.

I have never worked with Stored Procedures, and currently am managing the
SQL Server database through Access. I would appreciate some assistance both
in writing the procedure and figuring out how to trigger it at a specific
time (8:00 AM).

Here is what I have so far:
CREATE PROCEDURE dbo.ResetPickupFlag

AS

UPDATE Pickup SET PickupOccurred=False

GO

EXEC dbo.ResetPickupFlag

Currently, it returns the error "incorrect syntax near GO".

Any assistance you can provide would be appreciated.

Thanks.
Paul