First off, run this SQL query against the DB:
Code:
SELECT Email FROM Customer WHERE IsAdmin=3
If that returns anything, the email address(es) listed is the super admin user. That's the email address you'll want to use in the password reset query you used above.
If it doesn't return anything, then yeah the super admin account has been deleted. You'll need to 'promote' another user to super admin with this query:
Code:
UPDATE Customer SET IsAdmin=3 WHERE Email='the address you want to make a super user'
You can either promote an existing customer account, or just register a new account through the front end and run that script on the new account.
*Please ensure that you have a full, functioning backup before making any code modifications or file changes to your AspDotNetStorefront website, or running any ad-hoc queries against your database. Improperly making code modifications or running queries against your database can cause your website to be non-functional and/or your data to be permanently lost. As part of your disaster recovery plan, you should make regular backups of all files and data, and perform periodic checks to ensure your backups function properly. If you are not sure if your data is adequately protected, contact an IT professional or your hosting provider for assistance.