DBCC commands are generally only available to higher-level users.

e.g

DBCC SHOWCONTIG - sysadmin; db_owner; ddl_admin

DBCC DBREINDEX - sysadmin; db_owner; ddl_admin

I guess your read-only user ISN'T a member of these roles, otherwise...

Edward,

some thoughts.....

Option1 took 5 hours - how were you looping? please don't say you used an incrementing counter?

In Option2

instead of getting the Top 1 recnumber from (top 100000 recnumbers ascending)...

You could also publish a distribution graph so we can see how many members are at each level?

Certainly nothing wrong with that approach.

If you did remove owner, manager and requestor into another table, then you would essentially be creating a one-to-one relationship between that tuple and the...

Hate to moan but isn't this question a bit like

You have a SQL2000 database but you cannot connect to it. What is the problem?

A) it is switched off

B) you have...

I'd love to find a real-world example of this code being neccessary....and then run a mile. 😉