I am developing around sql server express 2005, and I have a database that I, and a few other people work on. Right now whenever someone needs to make changes, they need to go to where the database is on the server, copy it locally, attatch it, make changes, detatch, and copy it back over to the server... There must be another way. I tried adding the database to a project solution in SourceSafe, but that doesn't seem to make things any easier. Anyone have any suggestions?
Have a database on the server and have the Enterprise Edition in the clients from where you want to edit and change the database from the client.
Thank you for your quick reply. My SQL server background is quite limited, perhaps you could elaborate a little on your explanation.. I am not quite sure what you mean by Enterprise Edition.
By enterprise edition you mean.... as opposed to the express edition that I am currently using. I am not using enterprise edition, I am using sql server 2005 express.
What I meant is SQL Server comes with Query browser that you should install in the clients and that only the Enterprise edition has that facility and not with the personal editions as far as I know. I may be wrong.
I guess my question can really be simplified down to this statement: How does one remotely access a database through SQL Server Management Studio Express?
Ok, I figured it out, I feel kind of silly now that I realize how simple my problem was... Thanks for your help.