In Chapter 9 of the Training Kit there is the following question:
Could you execute the sp_spaceused stored procedure against every table in a
specified database without the use of a Transact-SQL cursor?
The answer alludes to a solution but does not give it. It states: 'You
could use a SELECT statement to create a loop and execute the sp_spaceused
stored procedure against each table.'
This is the one question for which I have no answer.
Could someone please show me a solution to avoid using cursors.
Thanks in advance,