Developing CLR Objects - Visual Studio Requirements?

I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
on either system's VS installation the option to create a new Sql
Project/Solution to create CLR objects. Am I missing something, or do I
need VS Professional?
CraigHi Craig,
the option should be under
FIle --> New --> Project --> (Programming Language, e.g. C# ) -->
Database --> SQLServer project
In the Project you can define new object types like functions /
procedures / UDA etc.
HTH, Jens Suessmeyer.|||AFAIK, you need VS Professional version or (beta of) Team System dev.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/bobb
"Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
>and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
>on either system's VS installation the option to create a new Sql
>Project/Solution to create CLR objects. Am I missing something, or do I
>need VS Professional?
> Craig
>|||You don't need to use Visual Studio to create and run
assemblies in SQL Server:
http://www.eggheadcafe.com/articles...5_clr_regex.asp
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp
"Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
>and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
>on either system's VS installation the option to create a new Sql
>Project/Solution to create CLR objects. Am I missing something, or do I
>need VS Professional?
> Craig
>|||True. By the description in the posting, it appeared that he was looking for
the built-in Visual Studio "SQL Server Projects" for .NET languages, that
are included as part of some editions of Visual Studio.
You could conceivably develop and deploy SQLCLR assemblies with a command
line compiler and SQLCMD.exe.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:%23XoVWSLDGHA.3984@.TK2MSFTNGP14.phx.gbl...
> You don't need to use Visual Studio to create and run
> assemblies in SQL Server:
> http://www.eggheadcafe.com/articles...5_clr_regex.asp
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> http://www.eggheadcafe.com/forums/merit.asp
>
>
> "Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
> news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>|||Niels Berglund has released an custom SQL Server project, VS addin and a
stand-alone SQL CLR deployment tool which work with any edition of Visual
Studio.
http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
David
"Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
news:%23AIOLzMDGHA.628@.TK2MSFTNGP14.phx.gbl...
> True. By the description in the posting, it appeared that he was looking
> for the built-in Visual Studio "SQL Server Projects" for .NET languages,
> that are included as part of some editions of Visual Studio.
> You could conceivably develop and deploy SQLCLR assemblies with a command
> line compiler and SQLCMD.exe.
> Cheers,
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
> news:%23XoVWSLDGHA.3984@.TK2MSFTNGP14.phx.gbl...
>|||Yep. I was aware of that too. ;-) It sounded as though the questioner was
asking/wondering why the built-in projects didn't show up, rather than what
are the choices when...
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:eYUIWFNDGHA.748@.TK2MSFTNGP12.phx.gbl...
> Niels Berglund has released an custom SQL Server project, VS addin and a
> stand-alone SQL CLR deployment tool which work with any edition of Visual
> Studio.
> http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
> David
>
> "Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
> news:%23AIOLzMDGHA.628@.TK2MSFTNGP14.phx.gbl...
>|||I was kind of asking both, mainly "how do I develop one without notepad.exe"
:) I found all of these posts to be both correct and very helpful, thank
you all.
Craig
"Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
news:uCuImBODGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Yep. I was aware of that too. ;-) It sounded as though the questioner was
> asking/wondering why the built-in projects didn't show up, rather than
> what are the choices when...
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:eYUIWFNDGHA.748@.TK2MSFTNGP12.phx.gbl...
>