December 19, 2002 at 5:14 pm
I store paths, in UNC format, to our servers and the applications that are to be run on them in our database. Then there are processes that query the table to determine what server to schedule an application to run on. However, the AT command documentation is clear that you should use local drive letters instead of UNC paths to schedule tasks.
We would like to avoid storing absolute physical locations in the table and just the server/share name and I was hoping that the xp_unc_to_drive procedure would take a UNC as an input parameter and return the local drive letter for that share.
December 19, 2002 at 5:36 pm
I don't neccessarily from this think you are going about what you really want. But I want to make sure I fully uunderstand. Can you give details on a bit of how the whole process works and what it should accomplish. I am confused especially when you say that xp_unc_to_drive but if there is only one SQL Server involved it will not be able to do anything like that on remote servers or am I wrond and each server is a SQL Server?
December 19, 2002 at 5:42 pm
In simple terms, we have a database that manages a series of genetic analysis processes. SQL server is the manager of the processes. In one table is the name of the different application servers and the particular process that are run on each. The SQL server procedure reviews current states of each analysis and determines which task needs to be run on which application server. The SQL procedure then creates the appropriate AT command to run the process on the application server. I maintain application server information as UNC share names, so that we have the flexibility to move applications referencing only share names. However, the AT command documentation is clear that it wants local drive letters and not UNC's. So, I want to be able to translate our UNC's to a drive letter so that I can dynamically build the proper AT command.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply