Since V9, there is that property CommandLine to the database server's command line.
However, it just returns the program arguments but does not contain the executable's path.
For example, on my box, the returned value for the SA 12 demo database is similar to
Is there a way to get the executable's path, too?
If not, I would like to suggest such a property.
(Workarounds seem not that easy, cf. my comments on John's answer.)
I don't see any property that would give you the executable's path but on Windows you could do it with an external function that calls GetModuleFileName().
answered 16 Feb '11, 21:22
@Volker: John's suggestion was to use an external function but have it loaded by the server rather than run it in an external environment. So basically your CREATE FUNCTION statement would not have a language clause. If you wrote such a function, then calling GetModuleFileName should work since the loading module is the server.
answered 17 Feb '11, 12:36