Skip to Content
0
Former Member
Jul 31, 2013 at 11:45 AM

dbcc checkstorage inside rpc

95 Views

HI

Im trying to set up regular dbcc checkstorage in our system and encountered a problem.

What it boils down to :

If i make a procedure, eg:

create procedure sp__dbcc_db_pubs

as

dbcc checkstorage (pubs2)

and a call it ,

exec sp__dbcc_db_pubs

everything works great, same as if i just manually enter dbcc checkstorage (pubs2)

But if i call

loopback...sp__dbcc_db_pubs -- loopback is correctly defined, everything else works ok

i get the following error

The entries in dbcc_config for database 'pubs2' are either missing or invalid. Use sp_dbcc_evaluatedb to determine appropriate values for the entries and sp_dbcc_updateconfig to set them.

The same thing happens with checkverify

I have ASE 15.0.3 ESD #4 on 64bit RHEL

Any thoughts why is this happening and how to fix it?

-- I need to do the checkstorage inside an RPC, because the login that is supposed to be running the checkstorage has indirect_sa_role, which i need to activate, as described in http://www.sypron.nl/grant_sa.html .

Thanks

Karel Ditrich