Help! Some dick deleted the Author for the default sharepoint site!

Hi All,

While I was doing the below, I had a problem.
Someone had deleted the default author for a site, this stopped the stsadm tool running.

Do this nice DB stuff to get it working.
First:

Select author, siteid from webs where fullurl =
'[yoursite]'

Remember the siteid!

run this one:

Select * from userinfo where tp_siteid='[that really long code you
just remembered]'

Now choose another user who is active and remember the tp_id

Now run this one:

update webs
set author = [that tp_id you remembered for the
user]
where fullurl = '[yoursiteid]'

Thanks for reading

Trev