I just thought I’d put this up here for my own future reference as I spent some time today mucking around trying to find out why a stored procedure would not deploy. I had a stored procedure file in my database project, that was not in the dbo schema section, so I wanted to move it into that area. When I dragged and dropped the file it moved locations, but did change the file to be included in the build. This needs to be edited by hand in the .dbproj file, from:
<NotInBuild Include="Schema Objects\Schemas\dbo\Programmability\DeleteStuff.proc.sql" />
To:
<Build Include="Schema Objects\Schemas\dbo\Programmability\Stored Procedures\DeleteStuff.proc.sql">
<SubType>Code</SubType>
</Build>
If it is left with the NotInBuild tag it will fairly obviously not include it, but this can quite annoying if you are not aware of it.
No Intellisense in Visual Studio 2010 RTM
May 28, 2010
This is just a quick one but if like me you have installed Visual Studio 2010 RTM and then wondered where your intellisense has gone then check this article about the VS2010 RC that Scott Gu wrote.
Simply put if you had ReSharper on VS2008 and don’t have it on your 2010 install and import your settings then you will have missing intellisense until you change your options.
