Community

Find Embedded SQL Server Logins in Jobs, Linked Servers or SSISDB

(Pablo Echeverria) A database login or user (SQL Login, Oracle User, etc.) is actively being used and embedded in code, but the password is about to change. How can you find all of the places where it exists with SQL Server such as Jobs, Linked Servers and SSIS information stored on the server?