Data Link Properties 关注

0
Avatar
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:

CreateObject("WScript.Network").computername
 
Any way to do this?  Thanks in advance.

 

请先登录再写评论。