With a Database project you can manage all of your database's objects' creation scripts - stored procedures, views, tables, user-defined functions, jobs, and so on - through Visual Studio .NET.
This offers a bevy of advantages, including:
1. Source control on database objects
2. A centralized development experience
3. An improved text-editor
4. Ease of deployment
For more, read them:
Database Projects in Visual Studio .NET [
^]
Visual Studio.NET Database Projects[
^]