Can I reference a machine environment variable in an SQL Server database and expect it to behave correctly?
I have a database entry that hard-codes a particular folder. I want it to be on D: drive for servers and C: drive for laptops and workstations. So I'm thinking if I set a system environment variable called DATADRIVE and set it to D:\Folder for servers and C:\Folder for workstations, then put %DATADRIVE% in the entry in the database table, might this work? It obviously depends on whether the value in the table is parsed based around the SQL Server itself, or the client reading the data. I'm going to test it tonight, but I'm just hoping someone out there knows off the top of their heads :-) Cheers, -- *James Rankin* ------------------------- RCL - Senior Technical Consultant (ACA, CCA, MCTS) | The Virtualization Practice Analyst - Desktop Virtualization http://appsensebigot.blogspot.co.uk
