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
dbcc checkstorage (pubs2)
and a call it ,
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 .