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 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply