Allow search on one server with different users
I used to have access to one server with different SQL users, each with access to different databases. However, SQL Search only uses the first user to search for objects, so only the databases for that user are shown. My workaround is to open SSMS a second time for the second connection, just so that SQL Search works as intended. It would be great to be able to see all objects from all currently logged-in users, or to manually select a user.
3
votes
