EXPERT RESPONSE
SQL Server 2005 has its own set of internal tables that users can not access. The set is used to perform operations like this. We can get a glimpse into what these tables do by looking at the definitions for the catalog and compatibility views. For instance, the following code shows the definition for the sys.sysindexes view:
select object_definition(object_id('sys.sysindexes'))
If you look at the output, you'll see that this view gets its value for FirstIAM from a column that results from the following expression:
OpenRowset(TABLE INDEXPROP, id, indid, rowset)
Unfortunately, users have no access to this special syntax -- attempting to use it results in an error.
|
