ADO error: CREATE PROCEDURE promission denied in database...

[Lotr]

My software engineering class was trying create a "New Stored Procedure" but when we went to save our procedure it gave us this error

"ADO error: CREATE PROCEDURE promission denied in database 'Northwind'."

I think that we need to be given additional rights somewhere in entiprise manager I just dont know how or where.

Thanks for your time,
lotr