Re: easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function
- From: "DR" <softwareengineer98037@xxxxxxxxx>
- Date: Tue, 13 Nov 2007 17:43:59 -0800
thanks but it turns out that no one should EVER manualy issue a CREATE
ASSEMBLY command. this is done via visual studio project settings. manualy
deploying CLR creates unessicary maintinence issues.
"Alexander Vasilevsky" <alvas@xxxxxxxxx> wrote in message
news:fgvaa7$1rjb$1@xxxxxxxxxxxxxxxxxxxxx
Please try CREATE ASSEMBLY (Transact-SQL)
Please see code below from BOL
DECLARE @SamplesPath nvarchar(1024)
SELECT @SamplesPath = REPLACE(physical_name,
'Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf',
'Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\')
FROM master.sys.database_files
WHERE name = 'master';
CREATE ASSEMBLY HelloWorld
FROM @SamplesPath + 'HelloWorld\CS\HelloWorld\bin\debug\HelloWorld.dll'
WITH PERMISSION_SET = SAFE;
http://www.alvas.net - Audio tools for C# and VB.Net developers
"DR" <softwareengineer98037@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:OQEkOloFIHA.3980@xxxxxxxxxxxxxxxxxxxxxxx
easiest way to upload a C# class library to a SQL server 2005 and deploy
as CLR function
Do I have to upload the .dll and then run sql command to load it into sql
server, or is there a more integrated way to do this in visual studio
2005 with a SQL Server Project? or do i have to manualu upload the DLL in
all cases? Any tutorial on CLR with Visual Studio 2005 IDE to Sql Server
2005?
.
- References:
- Re: easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function
- From: Alexander Vasilevsky
- Re: easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function
- Prev by Date: Re: I set my database to trustworthy and deployed this clr stored proc as unsafe ok but when i run this it returns 1 each time. as if ival keeps getting set back to 0 each time i call this clr stored proc. How to fix so that ival keeps its current value ea
- Next by Date: Re: How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with?
- Previous by thread: Re: easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function
- Next by thread: Re: How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with?
- Index(es):
Relevant Pages
|
