Me and my co-worker each got a copy of our website (asp and asp.net) on our machines, and a copy of the database.
The live version of the site and database are hosted in another city.

Each work on his version, and ftp changes over....and it became a nightmare.

We both need to work on the same web project and database.

I got us a server (Windows 2000), and will install Visuals Studio 2003 and SQL Server 2000 on it.

But something tells me that we will not just be able to open the web project on the server from our local machines from the Visual Studio installed on our machines.

What is the right way to go about?