I have a wcf service that reads and writes data from a sql server mdf file. On this remote machine(windows server 2008r2) there will be many copies of that mdf file(all with same name)but in different folders for different users. Each users PC
and windows phone app can connect to their own folder for data. Right now I have only one mdf file for testing and it is attached in SQL server. However when I tried to attatch a second one it sql server says it can't because it says databse of the same
name already exists.
How can I set this up on the remote machine SQL Server 2008 to work?
Thank You Jon Stroh
View Complete Post