Blog

I see a lot of internal views, such as sys.syscomments making calls to CROSS APPLY OpenRowset(TABLE SQLSRC, oid, int). I am wondering how this function operates and what it’s reading from, sys.syscomments OpenRowset(TABLE SQLSRC, o.id, 0) (o is sys.sysschobjs$ ) OpenRowset(TABLE SQLSRC, c.object_id, c.column_id) (c is sys.computed_columns) OpenRowset(TABLE SQLSRC, p.object_id, p.procedure_number) (p is sys.numbered_procedures) sys.all_extended_proceduresRead more