DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Jude 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
Version: All
Section: SQL Scripts