How do I allow non-SA to use DBCC from VB app ?

[Tim Scher]

Can I allow a non SA account to issue DBCC or TRUNCATE TABLE on a DBO table ?

I've tried setting this up in a SP where I've granted execute only to the user but the user receives "Only the DBO of the database may run the DBCC UPDATEUSAGE command".

Do I have to set the user up as an alias to DBO ? I'd rather not.

[Gregory]

permission to excute DBCC updateusage() : sa or dbo only and isn't transferable.

what if you schedule a task to run every night , for example, for dbcc updateusage?

------------
Tim Scher at 3/15/99 10:42:27 AM

Can I allow a non SA account to issue DBCC or TRUNCATE TABLE on a DBO table ?

I've tried setting this up in a SP where I've granted execute only to the user but the user receives "Only the DBO of the database may run the DBCC UPDATEUSAGE command".

Do I have to set the user up as an alias to DBO ? I'd rather not.

[Gregory]

you can also create a simple batch file, that your application will run upon request

in batch file, put this line:
isql -Usa -P<sa password> -S <server name> -d <database name> -Q &#34;dbcc updateusage(0)&#34;

that will run dbcc update usage for <database name>.
for more information about iSQL command line utility see books online

------------
Gregory at 3/15/99 12:05:53 PM

permission to excute DBCC updateusage() : sa or dbo only and isn&#39;t transferable.

what if you schedule a task to run every night , for example, for dbcc updateusage?

------------
Tim Scher at 3/15/99 10:42:27 AM

Can I allow a non SA account to issue DBCC or TRUNCATE TABLE on a DBO table ?

I&#39;ve tried setting this up in a SP where I&#39;ve granted execute only to the user but the user receives &#34;Only the DBO of the database may run the DBCC UPDATEUSAGE command&#34;.

Do I have to set the user up as an alias to DBO ? I&#39;d rather not.