Tuesday, February 14, 2012

Determining Object Ownership

How do I determine the ownership of an object? (i.e. table)
SELECT USER_NAME(OBJECTPROPERTY(OBJECT_ID('table_name'),' Ownerid'))
Thanks
Yogish
Posted by mars at 8:21 AM
Labels: , , , , , , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)