Looking for opinions here on what is the best way to programmatically test that a password change to a credential has occurred successfully.
The password change was made using Alter Credential, and I can see in sys.credentials that the credential was updated by the tool that handles these updates. I would just like to be able to confirm that all of the credential updates were successful (in other words, they authenticate correctly) before anything starts to fail.
Assume that the number of SQL Servers is too great to manually check them even if the whole team worked on it together.
Thanks in advance!!
I think there is no such DMV or DMF available in this case and for multiple servers you might need to wrap in to a stored procedure to execute on relevant servers using SQLCMD scripts & variables.
No comments:
Post a Comment