use master;
go
select objectproperty( object_id( 'sysprocesses' ) , 'TableIsFake' ) AS IsTableFake;
/*
IsTableFake
-----------
1
*/
select objectproperty( object_id( 'sysprotects' ) , 'TableIsFake' ) AS IsTableFake;
/*
IsTableFake
-----------
1
*/
select objectproperty( object_id( 'syspermissions' ) , 'TableIsFake' ) AS IsTableFake;
/*
IsTableFake
-----------
0
*/