Visual Studio 2013 SQL Server database project build failure

Question

I'm playing with a SQL Server database project with Visual Studio 2013 on Windows 2012 R2. Below is my code and you can download the whole project source code 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 build the solution, I got the following message.

------ Build started: Project: UDF, Configuration: Debug Any CPU ------ Creating a model to represent the project... Done building project "UDF.sqlproj" -- FAILED.

Build FAILED. ========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========

Essentially it tells me the build failed but I can't find any specific errors. Also there is nothing listed under the Error List pane. Please point me the right direction?

Have you looked at this related question: stackoverflow.com/questions/25774471/… — Dan
– Dan, Commented Mar 19, 2015 at 9:13

I A Khan · Accepted Answer · 2015-03-19 12:24:41Z

10

+500

You need to install the last 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 install restart computer and try to build again.

answered Mar 19, 2015 at 12:24

I A Khan

8,92716 gold badges57 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Just a learner Over a year ago

Thank you a million Imran! I've upgraded my SSDT from 12.0.41012.0 to 12.0.50226.0 and it fixed my problem.

Collectives™ on Stack Overflow

Visual Studio 2013 SQL Server database project build failure

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related