Friday, March 9, 2012

Query to find all pseudo tables

Whats the query i can use to find all pseudo tables such as
sysprocesses,syslocks,etc..Got it...
select name from sysobjects where OBJECTPROPERTY ( id,'Tableisfake') = 1
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OJcqYPCdDHA.904@.TK2MSFTNGP11.phx.gbl...
> Whats the query i can use to find all pseudo tables such as
> sysprocesses,syslocks,etc..
>

No comments:

Post a Comment