Anyone know the best way to attach a database that is created with SQL Server Studio as a database file in Visual Studio? I created a database with Studio and now decided to copy it to local folder and attach it to VS but it doesn't allow me to do so.
Error: The database with the same name exist, or specified file can not be opened or it is located on UNC share
I know the problem comes from different Server name
eg: my old server name is XXX\SQLEXPRESS
my new server name is YYY\SQLEXPRESS
Because I attach database into another pc not the pc that I created the database. And one more thing is that I used Windows Authentication in the old server.
Should I detach database within Studio and copy it over will help???
Error: The database with the same name exist, or specified file can not be opened or it is located on UNC share
I know the problem comes from different Server name
eg: my old server name is XXX\SQLEXPRESS
my new server name is YYY\SQLEXPRESS
Because I attach database into another pc not the pc that I created the database. And one more thing is that I used Windows Authentication in the old server.
Should I detach database within Studio and copy it over will help???
Comment