Welcome! Log In Create A New Profile

Advanced

WX12 - HFCS - Know the name of the server in a stored procedure

Posted by Peter Holemans 
Forum List Message List New Topic
Peter Holemans
WX12 - HFCS - Know the name of the server in a stored procedure
June 06, 2008 10:44AM
Hi,

I'm creating a stored procedure that will be triggered by a 'Scheduled Task' in HFCS. For doing so, you need to use hdeclareexternal for all files used and define the connection. However, in order to be able to run on different HFCS servers I would liek to test the name of the HFCS server the stored procedure is triggered in. Is there a way to know the name of the current server on which the stored procedure is running so I can dynamically define the connection in hdeclareexternal for the files used?

Thanks,

Peter
Reply Quote
Carlo Hermus
Re: WX12 - HFCS - Know the name of the server in a stored procedure
June 06, 2008 10:59PM
Peter,

Does NetMachineName() do the trick?
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: