How do I list my Salesforce users in SQL Server?

  1. Use the Salesforce ODBC driver to connect SQL Server to Salesforce.
  2. Run this query:
    SELECT * FROM OPENQUERY(linked_server, 'SELECT * FROM [User]')
    

    Replace linked_server with the name of the linked server you created to connect to Salesforce.

    The User table is enclosed with square brackets as "User" is a reserved word in SQL and ODBC.