Browse by Tags

• enhancement
• entity
• expiry
• password
• property
• schema
• security
• sql server
• tsql

How to find all the owners of entities contained in a specified schema?
04 October 07 01:00 AM | SQL Master | 2 Comments   

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(schema_id) = '<schema_name>' Read More...

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

TSQL to find a login's properties such as password expiration?
23 July 07 05:22 AM | SQL Master | 1 Comments   

declare @name nchar ( 100 ) SET @name = '<LoginName' SELECT LOGINPROPERTY ( @name , 'PasswordLastSetTime' ) AS PasswordLastSetTime , LOGINPROPERTY ( @name , 'IsExpired' ) AS IsExpiried , LOGINPROPERTY ( @name , 'IsLocked' ) AS IsLocked , LOGINPROPERTY Read More...

Filed under: tsql, expiry, password, login, property