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.
Related Q&A from Adam Machanic
SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert...continue reading
Database servers needed for a site with thousands of users can vary depending on a number of factors, including your necessary level of load ...continue reading
Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.