If you run Dynamics GP and have more than a handful of companies, I am sure you have felt the pain of installing or upgrading a 3rd party product, and then having to log in to each company as “sa” to complete the install process. I had to do this recently for a new 3rd party we are using ( SmartView from eOne Solutions ). Once the install is complete, a log in to each database as “sa” is required to create the necessary tables to support the tool.
Visit site:
Use Dynamic SQL To Generate a Dynamics GP Login Macro