Hi friends,
Would you like to tell me that the different ways to deploy an assembly? Tell me that how to identify that an assembly is public or private please explain?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Dec 30, 2011, 12:58 AM
There are three different ways to deploy an assembly they are
1. Using a MSI Installer
2. Using a CAB archive
3. Using a XCOPY Command
Please refer the below link
http://msdn.microsoft.com/en-us/magazine/cc164080.aspx
Thanks
Prasant JinagaPosted Dec 30, 2011, 12:32 AM
If you want to Deploy Assembly in sql server,
1.Enable the CLR to 1
exec sp_configure 'clr enabled',1
2.Register Assembly in sql
CREATE ASSEMBLY asmHelloWorld FROM 'Path of the Assembly'
3.Createa function or SP
CREATE FUNCTION clrHelloWorld
(
@name as nvarchar(200)
)
RETURNS nvarchar(200)
AS External NAME asmHelloWorld.[SQLServerCLRTest.CLRFunctions].HelloWorld
SELECT dbo.clrHelloWorld('Mark')
Please ind the attached Code sample.
Thanks,
prasant