SQL Suspected database recovery


exec sp_configure 'allow updates',1
above run in master 
reconfigure with override 
above run in master 
begin tran update master..sysdatabases
set status=32768 where name='post'
if @@rowcount = 1
begin commit tran raiserror('emergency mode set',0,1)
end
else
begin rollback raiserror('unable',16,1)
end
dbcc rebuild_log('post','d:\post.log')
 above run in master