Visual Studio 2013 SQL Server Database Project Build Error

Question

I am playing with a SQL Server database project with Visual Studio 2013 on Windows 2012 R2. Below is my code, and you can download the entire source code of the project from my shared Dropbox link at https://www.dropbox.com/s/aalnlwvxutr4g0f/UDF.zip?dl=1

using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction] public static SqlString Greetings(SqlString name) { // Put your code here return new SqlString("Hello " + (string)name); } } 

When I try to create a solution, I received the following message.

------ Build launched: Project: UDF, Configuration: Debugging Any processor ------ Creating a model to represent the project ... The finished building project "UDF.sqlproj" - FAULT.

Assembly FAILED. ========== Build: 0 failed or updated, 1 failed, 0 skipped ===========

In fact, this suggests that the assembly failed, but I can not find any specific errors. In addition, nothing is displayed in the Error List pane. Please point me in the right direction?

Answer 1

You need to install the latest version of SQL Server Data Tools here is the link

http://msdn.microsoft.com/en-US/data/hh297027

http://go.microsoft.com/fwlink/?linkid=393521&clcid=0x409

after restarting the computer and try creating again.