I'm using FME 2020.2, connected to SQL Server 2014 as sa with a database specified using the non-spatial connector. I am trying to create automated Excel reports for SOX audits using three SQLExtractors running one of these each:
sp_helpsrvrolemember
sp_helprotect
sp_helprolemember
The results I am getting do not include all the rows I get with SQL Server Mgt Studio connected to the db specified in the FME connection. I also tried adding "Use DBNAME" as the pre-sql with no change.
Help me to understand why this is, and how I can get the same results as SSMS (hopefully).
Thanks...
Bryan