Database development approach that fits into agile development methodology

We wanted to store the database project in a source control system. Every official version of the database project must be in Source Control and in a manner that made it very easy to establish which scripts we required for which build, and in which order we needed to apply them. We wanted to banish forever the days when we'd need to search around in Source Control - or worse, on the developer's machine - for the correct files.