Browse by Tags

How to find all the owners of entities contained in a specified schema?

Published 4 October 7 3:0 AM | SSQA.net

How to find all the owners of entities contained in a specified schema? USE <database_name>; GO SELECT 'OBJECT' AS entity_type ,USER_NAME(OBJECTPROPERTY(object_id, 'OwnerId')) AS owner_name ,name FROM sys.objects WHERE SCHEMA_NAME...

Filed under: sql server, security, login, tsql, enhancement, schema, entity

Enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function

Published 16 July 7 3:53 AM | SSQA.net

You may be aware OBJECT_NAME function can be use to return the database object name, I think since SQL 2000 when system functions are used the parameter of a system function is optional, the current database, host computer, server user, or database user...

Filed under: sql server, sp2, tsql, object_name, enhancement, schema