Am I missing something here? It seems that the only options to create a new table in a database project in VS2010 is: Create a table object as a file, then create all constraints (defaults) as sep...

I just started working with the Visual Studio 2010 Premium database project. I must say it does indeed rock. One thing I can't figure out is how to avoid the SQL04151 warning Procedure: [dbo].[M...

When using vsdbcmd to deploy my database: vsdbcmd.exe /a:Deploy /manifest:MyDatabase.deploymanifest I Get: SQL01268 .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line 6 Rows wer...

Code analysis rule SR0007 for Visual Studio 2010 database projects states that: You should explicitly indicate how to handle NULL values in comparison expressions by wrapping each column that ca...

I had hoped that Visual Studio 2010 would have brought some improvements to the Schema Comparison function. I suspect there are some, but I can't get something basic working. I've sucked in a schem...

I have a scenario where I am using a visual studio 2010 database project to deploy changes to multiple database installations, but on certain ones I want to exclude a set of views from that copy. I...

First of all, I know that the error I am getting can be resolved by creating reference project (of type Database Server) and then referencing it in my Database project... However, I find this to be...

I have a database project in visual studio (2008) that I am using to keep my database structure in a version control system (Git). I use the data schema compare tool in VS to maintain this database...