RSS

Retrieving a list of AX databases from SQL Server

07 Aug

i was trying to get list of AX databases on SQL Server.Microsoft Dynamics AX have capability to get list of database exists in SQL Server.it contains class SysDatabaseList.

SysDatabaseList sysDatabaseList;
container conDatabaseList;
Counter conlength;
Counter loopCounter;

sysDatabaseList = new SysDatabaseList();

conDatabaseList =sysDatabaseList.databaseNames();

conlength = conLen(conDatabaseList);

for(loopCounter = 1;loopCounter <= conlength;loopCounter++)
{
info(strFmt(“%1”,conPeek(conDatabaseList,loopCounter)));
}

🙂

Advertisements
 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: