I want to work in a wireless network. My two (or more) computers are in that network, and I want one SQL Server 2008 database (for example with the name Test_SQL). I want from both computers write en raed on that database. So when I write something to that database with computer A, that computer B also has that data in the database.
I think you can create Tesl_SQL on the one of your computers (or your server working in the same wireless) and from any computer you can connect to that database by ODBC to update data
But how can I change the location of the database db, in this case Test_SQL? The data will place in C:\Program Files\Microsoft SQL Server\100\MSSQL10_50.MSSQLSERVER\MSSQL\DATA
Assuming you can create an ODBC (or other method) to the target database , than you don't need to place the data on a Network Share. You're actually connecting a SQL Server service - which has a database attached , In the odbc the connection will be to a SQL Server , such as MYSERVER\MYINSTANCE and then you reference a db
Two computers and one database
Posted - 02/21/2013 : 10:06:23
