Browse by Tags

All Tags » login » entity (RSS)
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: , , , , , ,