Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
BenD 1/8/2015 9:30:22 AM

Drop a set of users from all databases

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

I love my job. Really.

I received this question via email today and it was so interesting that I decided to blog it.

One of our clients used to use pdk for timesheet entry but stopped several years ago. We now have over 100 users listed in sql under multiple databases that we’d like to remove. They all end with “_pdk”. Can you come up with an efficient way (more efficient than one at a time) to delete these SQL users and any related security records in each database?

 

Does anyone have an idea? Try and answer it before you look at my answer, see if yours is better.

4Penny.net
Version: All
Section: SQL Scripts






Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables