Browse by Tags

All Tags » Microsoft Dynamics GP Security   (RSS)
11 November 2008
Dynamically Get GP database connection information when using VBA
Dynamically Get GP database connection information when using VBA: 'Class Module: GP Dex_VBA_Link 'Author: Matt Connor 'Version: 2.01 'Updated: 06-Apr-2006 'Connection Properties Public PasswordUnencrypted As Boolean Public SQLPassword, SQLPasswordDecoded Read More...
0 Comments  
11 November 2008
Drop and recreate database Logins
Script below loop database users then drop and recreate them one by one: DECLARE @UserName Varchar(500) DECLARE UsersCurr Cursor For Select Name FROM sysusers WHERE (islogin = 1) AND (name <> 'dbo') AND (name <> 'guest') Open UsersCurr Fetch Read More...
0 Comments