Called From Where?

  • So I have a .sql file that runs version changes on a db i have. This file is bundled into a folder and then given to many users. the users may have this folder in various locations on there hard drive. In my script I want to know where it is being executed from.

    Example

    C:\

    or C:\WorkingDirectory\

    or.....

    I have a solution but I would like to do this all through TSQL. This is run from a .exe

    Thanks

  • you have access to that informatino in your exe

    in vb6 it's app.path returns the folder the exe is running from

    in .NET it's Application.StartUpPath;

    it depends on what language you wrote your exe, but it's available.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply