Tuesday, March 6, 2012

.NET assembly

Can I reference a .NET assembly in MS-SQL 2005 Workgroup like we do with COM
objects
Thanks"Julio Delgado" <jdelgado89@.hotmail.com> wrote in message
news:u%23ll%23BhwGHA.888@.TK2MSFTNGP02.phx.gbl...
> Can I reference a .NET assembly in MS-SQL 2005 Workgroup like we do with
> COM objects
Yes CLR integration is available in every edition of SQL Server 2005. But
.NET isn't COM, and the procedure is different. You need to install the al
l
required assemblies in SQL with CREATE ASSEMBLY (or let Visual Studio do it
for you). Then surface specially written .NET methods as a clr stored
procedures or functions.
Programming SQL Server 2005 Using the .NET Framework
http://msdn.microsoft.com/sql/learn...lr/default.aspx
David

No comments:

Post a Comment