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.

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