VS 2005 Project of type Database Project

  • I have been reading up on CLR assemblies and quite a few articles make reference to starting a new project of type "Database Project".

    I got my copy of SQL Server 2005 and VS 2005 at the joint SQL/VS launch and I don't seem to have these project types.

    Does anyone know where I can get them from?

  • in VStudio :

    New => Project =>Visual C# => Database

    by default it'll be SQL Server DB pjt. Use this if u dont have your templates.

  • You get a minimal version of VS 2005 with SQL Server 2005 Developer Edition, this is all you get. There aren't any C#, VB or C++ options. . .

    Microsoft Visual Studio 2005

    Version 8.0.50727.42  (RTM.050727-4200)

    Microsoft .NET Framework

    Version 2.0.50727

    Installed Edition: IDE Standard

    SQL Server Analysis Services  

    Microsoft SQL Server Analysis Services Designer

    Version 9.00.2047.00

    SQL Server Integration Services  

    Microsoft SQL Server Integration Services Designer

    Version 9.00.2047.00

    SQL Server Reporting Services  

    Microsoft SQL Server Reporting Services Designers

    Version 9.00.2047.00

  • OK I am particularly interested in developing CLR functions, aggregates and procedures.

    Does anyone know of a download that would provide the datatypes or is there a general work around to allow me to write such functions?

    Also, how do you debug a CLR function?

  • What about the VS Express version? Haven't tried it myself.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply