Explanation:sp_who reports snapshot information about current SQL Server users and processes, including the currently executing statement and whether the statement is blocked. 7. _____________ displays an estimate of the current amount of disk space used by a table.
A. sp_lock
B. sp_who
C. sp_monitor
D. sp_spaceused
Answer:A
Explanation:sp_who reports snapshot information about current SQL Server users and processes, including the currently executing statement and whether the statement is blocked. 7. _____________ displays an estimate of the current amount of disk space used by a table.
A. sp_lock B. sp_who C. sp_monitor D. sp_spaceused
Explanation:sp_spaceused displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database. 8. Which of the following field in the following code is qualified name ?