After using for some time MS SQL Server Management Studio for creating and editing databases I tried to use Visual Studio 2010 "SQL Server 2008 Database Project" for this.
I used the SQL 2008 Wizard for importing existing database to VS2010. Everything went ok. Build succeeded as well. But when I try to deploy the database back to the server under another name I got lots of errors of type "Procedure: XXXX has an unresolved reference to object XXXX".
I'm surprised because all these stored procedures in fact work well and SQL Server Management Studio never complained about them. What could be wrong?