Hi,

I run the query through Linked server and get bad results

SELECT * FROM remote_server.master.sys.server_principals 

Is it possible to get correct results from table server_principals and other system security tables remotely?

I would like to run script and collect security information (logins, user, roles, schemas) from one server instance and avoid running that script on each server.

Thanks

Hi Jori,

If you are wanting to pull common system data from a group of servers I would strongly recommend you take a look at Central Management Server instead of linked servers.  You can have one query window open that connects to all servers in a group you establish and it will pull the result set back into one result set for you.

Here is a quick 4 minutes video I did on this exact problem a few years ago. https://www.youtube.com/watch?v=tZKtV2D4zyk

Let me know if this works out for you or if you have any questions.

Regards,
John