INFORMATION_SCHEMA.PARAMETERS
Is anybody able to access system tables used byINFORMATION_SCHEMA.PARAMETERS?
Namely:sys.sysscalartypes,sys.sysschobjs andsys.syscolpars.
A select on any of these failes with'Invalid object name'
Is anybody able to access system tables used byINFORMATION_SCHEMA.PARAMETERS?
Namely:sys.sysscalartypes,sys.sysschobjs andsys.syscolpars.
A select on any of these failes with'Invalid object name'
These are system base tables that are used by the database engine only.
Please see http://msdn2.microsoft.com/en-us/library/ms179503.aspx
Is there a reason why you would want to access these base tables ?