So....I deleted my host account when using the SQL module to delete old users from my Users db table.

What can I do to reset this account so I can log in as host?

It depends on which record you deleted, i.e. in table Users only???

I guess your solution is as follows: try to check which was the primary key of the host account (UserID filed in table Users).  I guest it should be 1, and this is the record which you deleted.

Then run the following:

SET IDENTITY_INSERT products ON
GO

-- make sure this is your users table name, i.e. you do not have a qualifier or different owner
INSERT INTO [dbo].[Users]
           ([UserID]
           ,[Username]
           ,[FirstName]
           ,[LastName]
           ,[IsSuperUser]
           ,[Email]
           ,[DisplayName]
           ,[UpdatePassword]
           ,[IsDeleted]
           ,[CreatedByUserID])
     VALUES
           (1
           ,"host"
           ,"SuperUser"
           ,"Account"
           ,1
           ,"youremail@email.com"
           ,"DisplayName"
           ,0
           ,0
           ,-1)
GO

SET IDENTITY_INSERT products OFF
GO

Evan Camilleri
http://www.DotNetMushroom.com

You can also open up the Users table and mark a user as a superuser. You should first register a new user, then promote that user to superuser status.

Thanks...I will give this a try.

First off to backup the db

that's always rule number ONE

And it's also Rule Number TWO! 

Agreed.   I wouldn't get in these predicaments if I had followed the rules.

On the other hand, I cannot believe how easy it was to enable the Superuser account.   Makes me feel a little better knowing I can easily just create another if things go bad again.

Thanks again for the info