What should be the DBCC
commands be called ? DBCC procedure or DBCC function?
It is confusing because DBCC PAGE
could be executed without prefixing a EXEC
statement much like stored procedures. But EXEC DBCC PAGE(1,1,1,3)
throws an error
Syntax error - Msg 156 Incorrect syntax near the keyword 'DBCC'
And it isn't a function because function calling must be made in SELECT
, but
SELECT DBCC PAGE(1,1,1,3)
shows the same error.