I have a sql script to attach my DB as follows:
CREATE DATABASE [myDB] ON
(FILENAME = 'C:\Documents and Settings\All Users\Application Data\myDB\mydb.mdf')
(FILENAME = 'C:\Documents and Settings\All Users\Application Data\myDB\mydb_log.ldf')
Now I want to run this script on a computer installed with a German OS but SQL Server installation is English. do I have to make a different script for each language replacing the DB location folder. Because 'C:\Documents and Settings\All Users\Application
Data' in english is not the same in German. Is something similar to Environment.SpecialFolder.CommonApplicationData available in SQL?
View Complete Post