Setting up for developing a CLR Stored procedure RRS feed

  • Question

  • Noob warning: I'm reasonably experienced in SQL Server, but only a little is VS.

    I have SQL Server 2008 R2 installed with SP3.

    I want to create a CLR stored procedure following the example on this page.

    I first tried with VS 2008 Express which I already had installed, but there is no database/Sql Server project template. I've since tried installing different versions VS, and currently have VS Ultimate 2013. This version does have a Sql Server project template, but that seems to be about creating a database and not about creating a CLR stored procedure.

    So what's going on? Do I need to install a different version of SQL Server?

    BTW, I did run devenv.exe with the /installvstemplates switch.

    Wednesday, April 30, 2014 8:02 AM


  • Hi,

    In VS2012 and VS2013 Ultimate, only SQL Server Database project template is provided instead of SQL CLR stored procedure project. You need create a SQL Server Database project first and then add ‘SQL CLR’ or ‘SQL CLR C#’ item into this project in order to create CLR stored procedure project.

    For more information, please see: http://stackoverflow.com/questions/12038952/sql-clr-project-in-vs2012

    Best regards,

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by Amanda Zhu Thursday, May 1, 2014 7:43 AM
    • Marked as answer by Amanda Zhu Tuesday, May 6, 2014 8:40 AM
    Thursday, May 1, 2014 7:43 AM