Jude
4Penny.net
Points: 7584

8/28/2018 8:40:19 AM

Run a script against all Dynamics GP company databases

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

I received an email today that asked how to run a SQL command against all company databases, so let's look at that technique

The request was to run this code:

USE DATABASE
DECLARE @O_iErrorState int, @I_dAgingDate datetime
select @I_dAgingDate = convert(varchar(10), GetDate(), 102)
EXEC dbo.rmAgeCustomer 0, '', 'þþþþþþþþþþþþþþþ', @I_dAgingDate, 127, 0, 0, '', @O_iErrorState OUT
SELECT @O_iErrorState
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
3