Knowledge Sharing
Pages
Cloud
AI-ML
SQL Arch.
Demo
Performance Issues
PostgreSQL
Scripts
Finance
Fabric
When My SQL Login Password Last Reset
/*******When My SQL login Password last reset********/
SELECT
LOGINPROPERTY
(
'SQL user'
,
'PasswordLastSetTime'
);
SELECT
LOGINPROPERTY
(
'sa'
,
'PasswordLastSetTime'
);
--Note: This will only return detail for SQL user not windows user
Link to:
Frequently Used Queries For Audit In Sql Server
3 comments:
Unknown
January 30, 2016 at 4:52 PM
Thanks for the post
website development
Web development Company
Reply
Delete
Replies
Reply
Kumar
August 29, 2016 at 1:14 AM
Good. Thanks.
Reply
Delete
Replies
Saurabh Sinha
August 29, 2016 at 2:12 AM
welcome
Delete
Replies
Reply
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Thanks for the post
ReplyDeletewebsite development
Web development Company
Good. Thanks.
ReplyDeletewelcome
Delete