HI all,

I am trying to write few queries for fetching some usefull data
from the system tables like sysprocesses,sysdatabases,sysusages etc.
But I read somewhere that we cant directly perform "join operations"
and use "aggregate functions" on these tables(specially dynamically
created tables like sysprocesses,syslocks etc). Is there any
documentation provided where I can find some usefull information on
how to "Join" these tables and those stuff so that I can fetch some
usefull data from these tables.
Does Joining these tables simultaneously result in Deadlock or
such conditions.

Please help me to sort this out.

Thanks in Advance

Regards,
Amol

I join on these tables all the time. Try it.


"Amol Natekar" <amol.natekar (AT) exact-solutions (DOT) com> wrote

amol.natekar (AT) exact-solutions (DOT) com (Amol Natekar) wrote in message news:<93387fb2.0408040522.4d7ba429 (AT) posting (DOT) google.com>...
"Somewhere"? Please either get specific about what you
are reading, or just go ahead and try to do what you want to do.
I'm not aware of any such restrictions - if you encounter an
actual error, post that and we can discuss why it is happening
and how you can get around it. Just try joining them like any other
table. The main thing is not to involve system tables in big
transactions - you don't want to hold locks on them for long or
you block other users. But quick queries are generally perfectly fine.

-bret