THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Louis Davidson

Easier access to metadata coming soon to a SQL Server near you

This is not a scoop or anything, but it is quite newsworthy.  It is also a good way to kick off my sqlblog er...blog:

Kalen Delaney - Metadata Power
Simon Sabin - object_name() to be extended in SP2

A very common request is to have some of the system functions to work in any database.  Kalen posted a piece of feedback on connect to allow the object_name function to work with an optional second parameter of database_id!  Wow!  Thank you thank you!  I hope this becomes a standard feature on all of the database specific functions...

And for those of you who (like me) have started to embrace schemas, they also added a function: object_schema_name that returns the schema_name of the object. 

I had also asked for something like the latter, but they just closed it and told me to do this:
SCHEMA_NAME(OBJECTPROPERTY(<object_id>, 'schemaid')).   Well, I would listen to Kalen over me too :) 

Crossposted on drsql.spaces.live.com

 

Published Monday, September 25, 2006 7:35 PM by drsql

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Links to my other sites

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement