Thanks Calvin, that's well handy!

 

Ben

Calvin,

I'm aware that the system tables are subject to change without notice and will have to monitor service pack changes. Is there a way to programmatically obtain service pack information...

I think I've just found my new wallpaper for my office!!

Thank you very much Frank. I was just looking at the system tables in BOL, and you're right, it would...

Haha, I like that. Isn't it always the way.

I have looked at one particular library to do this but their licensing conflicts with my client's long term interests.

Looks like I'll...

Frank,

Firstly, apologies if this response appears to be posted twice. I'm sure I sent a response earlier, but it doesn't appear to have been sent!

I did indeed misread your earlier...

Frank

Take the following query:

 

select *, OBJECT_ID(Table_Name) as ID 

from information_schema.tables 

where OBJECTPROPERTY(OBJECT_ID(Table_Name), N'IsTable') = 1

and OBJECTPROPERTY(OBJECT_ID(Table_Name), N'IsMSShipped') = 0

and OBJECTPROPERTY(OBJECT_ID(Table_Name), N'IsSystemTable') = 0

and OBJECTPROPERTY(OBJECT_ID(Table_Name), N'TableIsFake') = 0

The performance hit on...

I'm aware of this, and thanks, but I need to be able to programmatically create a class hierarchy, akin to SQL-DMO, based on the results of individual queries. I feel...

Frank,

Thanks for the info. It's a good starting point although I'm trying to build something that is a lot more comprehensive.

 

Thanks

Ben