Data Link Properties Follow

Legacy Poster

Using the SQL Server Database option, I'd like to use the Custom SQL to filter by HOST_NAME() which should be the user WorkStation ID but apparently it is not.  


Our need is to use the system on multiple machines, but using the same bartender template connected to the server database.  So I need a way to distinguish the user's generated data.  Most everything runs on transaction SQL Server SP.  


When I query the HOST_NAME() it always brings back my 'Workstation ID' which I can see is located as a Data Link Property under :


Database Connection Setup -> Options -> Setup -> All -> Workstation ID


If we are able to use VBscript to change this value OnOpen, we can simply update that value with:

Any way to do this?  Thanks in advance.


Please sign in to leave a comment.