November 1, 2006 at 10:20 pm
SYSOBJECTS.ID = SYSINDEXES.ID
SYSDATABASES (what is the relationship?) will I have to join syslocks, sysprocesses to make this join happen?
Thanks...Michelle
November 2, 2006 at 5:26 am
If you get a copy of the resource kit, included in msdn and technet subscriptions, there is an electronic interactive view of the system tables.
sysobjects and sysindexes are local to each database, sysdatabases is common to the server - I can't think why you'd really want to attempt to make such a join - I suppose a profiler trace - anyway you'd have to infer the joins as sysobjects does not contain a database id as it knows where it is.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
November 2, 2006 at 7:40 am
That makes sense...thanks...
I found the system table map here:
http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx
Regards,
Michelle
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply