I dealt with GP years ago. Through some SQL traces and calls with GP support, we determined that the app needs sa for new logins and potentially new databases. However...

Generally, I do my best to never let a SQL login have any sort of elevated privs on a database let alone the server. We still have one program...

Great article! Did you meet the SLA? Congrats on the quick thinking.

Thanks Jeff for replying to such an old post. I'm new to supporting Dynamics GP, but it seems they are still having issues in the latest 2010 release as...

We had a similar deadlock problem with "Dynamics" (peviously known as "Great Plains"). My systems DBA and I engineered a fix, got the support team to buy into it, and...

Good article. I always like to see/hear how others are using version control on their databases. Currently, we version all objects not just stored procedures, functions and triggers....