Try this...
In the master database, issue the following: sp_configure "allow updates to system tables", 1 1. update sysdatabases set status = -32767 where dbid = id for DB <databasename> 2. checkpoint master database 3. shutdown and restart ASE Server The database should now be in by-pass recovery mode. 4. use database <databasename> 5. dump tran database with no_log 6. update sysdatabases set status = 0 where dbid = ID for db <databasename> 9. checkpoint master 10. shutdown and restart ASE |
Search This Blog
Saturday, 8 March 2014
database has not been recovered yet - please wait and try again
Msg 10332:SELECT permission denied on column audflags of object sysobjects, database
error:
Msg 10332, Level 14, State 1:
Server '%s%', Line 1:
SELECT permission denied on column audflags of object sysobjects, database dxpo, owner dbo
Simple resolution:
grant all on sysobjects to public
go
error
Msg 10331, Level 14, State 1:
Server '%s%', Line 1:
CREATE TABLE permission denied, database %s%, owner dbo
Msg 10332, Level 14, State 1:
Server '%s%', Line 1:
SELECT permission denied on column audflags of object sysobjects, database dxpo, owner dbo
Simple resolution:
grant all on sysobjects to public
go
error
Msg 10331, Level 14, State 1:
Server '%s%', Line 1:
CREATE TABLE permission denied, database %s%, owner dbo
Subscribe to:
Posts (Atom)