InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:16:06 GMT20http://www.sqlservercentral.com/Forums/Topic613481-149-1.aspx[quote][b]dbs.basu (9/5/2012)[/b][hr]try dbo.spt_values[/quote]yep 4 years old :)But yes- this table does give the references i was after...Good to have as a reference for future searches.Many thanks!Thu, 06 Sep 2012 02:08:34 GMTRin Sitahhttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspx[quote][b]dbs.basu (9/5/2012)[/b][hr]try dbo.spt_values[/quote]Note: 4-year old thread.Wed, 05 Sep 2012 17:55:15 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxtry dbo.spt_valuesWed, 05 Sep 2012 08:48:04 GMTdbs.basuhttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxBut I did just notice that under the Subclass value, we get the references that im after.That should be ok!Thanks for that!Fri, 13 Feb 2009 03:45:50 GMTRin Sitahhttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxKinda, but theres no entries for anything like say:Event_trace_id = 8278This corresponds to a Viewor Event_trace_id = 22601Should be an Index.So as far as I can still tell- that table I posted at the start seems like the only way of linking up opject types to the default trace...Fri, 13 Feb 2009 02:50:29 GMTRin Sitahhttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxhopping in very late .... but maybe this query gets you on the rails ...[code]Select * from sys.trace_subclass_values TSVinner join sys.trace_columns TC on TC.name = 'objecttype' and TC.trace_column_id = TSV.trace_column_id[/code]Fri, 13 Feb 2009 01:51:52 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxOops, sorry I thought that I had checked for that...Wed, 31 Dec 2008 08:30:40 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspx[quote][b]RBarryYoung (12/30/2008)[/b][hr]Select * from sys.types[/quote]Thanks for that, but that only returns Data Types. I want object types...Wed, 31 Dec 2008 02:37:32 GMTRin Sitahhttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxSelect * from sys.typesTue, 30 Dec 2008 16:02:56 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxI am going to guess by the lack of any response that no one knows if there is a system table that contains this information. Surprising. :(Fri, 05 Dec 2008 06:42:39 GMTRin Sitahhttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxNo one? Anyone know if there is a system table or view that contains that information? Surley somone must have an idea!Thu, 04 Dec 2008 08:32:38 GMTRin Sitahhttp://www.sqlservercentral.com/Forums/Topic613481-149-1.aspxHi there!I'm querying the default trace to get some audit info on some DB objects. (The variable @Trace contains the location of the default trace)[code]Select * FROM ::fn_trace_gettable(@Trace,0)[/code]In the ObjectType field from the trace, we get some reference numbers. eg 8278.I found on MSDN a reference table (of sorts) that releate these numbers to Meaningful names. [url]http://msdn.microsoft.com/en-us/library/ms180953.aspx[/url]Eg 8278 = ViewMy question is: Is there a system table that contains this information? Otherwise I will have to create my own lookup as per below.1 Index2 Database3 User Object4 CHECK Constraint5 Default or DEFAULT Constraint6 FOREIGN KEY Constraint7 PRIMARY KEY Constraint8 Stored Procedure9 User-Defined Function (UDF)10 Rule11 Replication Filter Stored Procedure12 System Table13 Trigger14 Inline Function15 Table Valued UDF16 UNIQUE Constraint17 User Table18 View19 Extended Stored Procedure20 Ad hoc Query21 Prepared Query8259 Check Constraint8260 Default (constraint or standalone)8262 Foreign-key Constraint8272 Stored Procedure8274 Rule8275 System Table8276 Trigger on Server8277 (User-defined) Table8278 View8280 Extended Stored Procedure16724 CLR Trigger16964 Database16975 Object17222 FullText Catalog17232 CLR Stored Procedure17235 Schema17475 Credential17491 DDL Event17741 Management Event17747 Security Event17749 User Event17985 CLR Aggregate Function17993 Inline Table-valued SQL Function18000 Partition Function18002 Replication Filter Procedure18004 Table-valued SQL Function18259 Server Role18263 Microsoft Windows Group19265 Asymmetric Key19277 Master Key19280 Primary Key19283 ObfusKey19521 Asymmetric Key Login19523 Certificate Login19538 Role19539 SQL Login19543 Windows Login20034 Remote Service Binding20036 Event Notification on Database20037 Event Notification20038 Scalar SQL Function20047 Event Notification on Object20051 Synonym20549 End Point20801 Adhoc Queries which may be cached20816 Prepared Queries which may be cached20819 Service Broker Service Queue20821 Unique Constraint21057 Application Role21059 Certificate21075 Server21076 Transact-SQL Trigger21313 Assembly21318 CLR Scalar Function21321 Inline scalar SQL Function21328 Partition Scheme21333 User21571 Service Broker Service Contract21572 Trigger on Database21574 CLR Table-valued Function21577 Internal Table (For example, XML Node Table, Queue Table.)21581 Service Broker Message Type21586 Service Broker Route21587 Statistics21825 User21827 User21831 User21843 User21847 User22099 Service Broker Service22601 Index22604 Certificate Login22611 XMLSchema22868 TypeFrom my quick look around, it would apear that this information does not exist in a system table or view. Does anyone know an better?Many thanks!Thu, 04 Dec 2008 02:13:02 GMTRin Sitah