How to create another admin once site is online

Hi, My clubsite is online and working and I have the need to assign admin privledges to another member. Is there a way to do this? I tried accessing the site through VS express 2008 and the website menu doesn't have the asp.net configuration option mentioned in the "welcome.htm". I tried going right into the data base on my server, but the darn thing is in code and I can't tell how to change a user from member to admin. I'd appreciate any suggetions if someone has done this already. Thanks.

Re: How to create another admin once site is online

if you already have the member created that you want as an admin, just run the stored procedure

dbo.aspnet_UsersInRoles_AddUsersToRoles.

DECLARE @return_value int


EXEC @return_value = [dbo].[aspnet_UsersInRoles_AddUsersToRoles]
		@ApplicationName = N'YOURAPPLICATIONNAME',
		@UserNames = N'USERNAME',
		@RoleNames = N'ROLENAME',
		@CurrentTimeUtc = N'CURRENTDATE'


SELECT 'Return Value' = @return_value

hope that helps