If you are not putting your database objects under source control, you should check out
this article by Jeff Atwood.
I have been investigating several methods and tools for database version control and I think I am going to settle on something as simple as using SQL Enterprise Manager to generate SQL scripts and store them in our existing source control tool (
Vault).
In the past I have used
ScriptDB4SVN, but it won't work in my current situation.
If you do have your database under version control, what process and applications are you doing it with?