I maintain SQL scripts for Stored Procs and UDFs in a VS2005 "Database
Projects" ("Other Project Types"). The Database project was added to
VSS for source control.

1) When Stored Procs, UDFs are edited outside this project (ie. From
SQL Management Studio), is there a way to synchronize updates into the
"Database project" scripts?

2) I created these scripts by draging and dropping database objects
from VS2005's "Server Explorer" dialog into the "Database project" in
"Solution Explorer". Scripts are automaically created. Nice :-))

But when I open a stored proc via the VS2005's "Server Explorer" dialog
and modify it, these changes are not reflected in the relevent scripts
in the "Database project". I was expecting that since I keep the
database project open, and since the database project has a reference
to the database, VS2005 could detect the changes and automatically
synchronize.

Could someone kindly explain to me whether I am not doing this
correctly?

Thanks
Sur

Count Occurances in a column
Who has the highest bid?
Need Help Please...
How to compare strings for equality in Transact SQL
Unique index on joined view for fulltext index