Dear all,
Until now I was using for our application SQLSErver 2008 express R2 and when creating a database from SQL admin studio with Windows admin right file was created inside the DATA folder of SQL server installation.
Then form my .NET application I was referring the connection string as normal and connect to database.
Now we try to move to LocalDB and we notice that if we do the same process, we are not able to create the database as it is failing with an error but instead if we create the database with a script it works but databse file is created in current login user
profile folder.
The proble we have now is that we need our application to be accessible through connection string from any user profile using the application as it was with SQL server 2008.
What is the correct way now to create database in such scenario ?
We usually create our database through and our application installer which is run as administr ...
Go to the complete details ...