How do I centralize sql server database

rhaazy's Avatar, Join Date: Jul 2007
Go4Expert Member
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?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.
rhaazy's Avatar, Join Date: Jul 2007
Go4Expert Member
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.
rhaazy's Avatar, Join Date: Jul 2007
Go4Expert Member
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.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.
rhaazy's Avatar, Join Date: Jul 2007
Go4Expert Member
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?
rhaazy's Avatar, Join Date: Jul 2007
Go4Expert Member
Ok, I figured it out, I feel kind of silly now that I realize how simple my problem was... Thanks for your help.