http://blogs.msdn.com/sqltips/archive/2007/03/23/object-name-enhancement-and-object-schema-name-addition-in-sql-server-2005-sp2.aspxSQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot. Pleaseen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sqltips/archive/2007/03/23/object-name-enhancement-and-object-schema-name-addition-in-sql-server-2005-sp2.aspx#2001719Sun, 01 Apr 2007 00:46:04 GMT91d46819-8472-40ad-a661-2c78acb4018c:2001719names girl boy » OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL …<p>PingBack from <a rel="nofollow" target="_new" href="http://babiesblog.info/object_name-enhancement-and-object_schema_name-addition-in-sql/">http://babiesblog.info/object_name-enhancement-and-object_schema_name-addition-in-sql/</a></p> http://blogs.msdn.com/sqltips/archive/2007/03/23/object-name-enhancement-and-object-schema-name-addition-in-sql-server-2005-sp2.aspx#3892970Mon, 16 Jul 2007 12:04:38 GMT91d46819-8472-40ad-a661-2c78acb4018c:3892970SQL Server Transact-SQL (SSQA)<p>You may be aware OBJECT_NAME function can be use to return the database object name, I think since SQL</p>