Uploading a .NET assembly to SQL Server

**Holf** · 06-14-2007, 10:56 AM

One of the nice things about SQL Server 2005 is the integration with .NET. If there is something that T-SQL will not do, you can do it in C# or VB.NET instead and then compile your code into an assembly.

You can then upload this assembly to SQL Server 2005 using the 'CREATE ASSEMBLY' command. However, to do this, you need to supply a fully qualified path to where your assembly (i.e. a .dll file) is located.

So... is this allowed with DiscountASP.net SQL Server 2005 hosting? And, if so, where can I put my .dll assembly file so that my SQL Server 2005 DB instance can find it?

Another way to import the .dll file is to provide the actual byte sequence of the .dll file directly into a CREATE ASSEMBLY command, but I've never tried this...

Any help much appreciated.

Holf

**raymondp** · 06-14-2007, 11:06 AM

Unfortunately this is not allowed with discountasp SQL servers. This will require specific righst to the user that will compromise the entire database server.

**Holf** · 06-15-2007, 11:28 AM

Thanks for the response Raymond.

Yes, that is quite understandable and I suspected this would be the case. I guess I'll just have to use good old T-SQL...

06-14-2007, 10:56 AM	#1
Holf Join Date: Jul 2006 Posts: 21	Uploading a .NET assembly to SQL Server One of the nice things about SQL Server 2005 is the integration with .NET. If there is something that T-SQL will not do, you can do it in C# or VB.NET instead and then compile your code into an assembly. You can then upload this assembly to SQL Server 2005 using the 'CREATE ASSEMBLY' command. However, to do this, you need to supply a fully qualified path to where your assembly (i.e. a .dll file) is located. So... is this allowed with DiscountASP.net SQL Server 2005 hosting? And, if so, where can I put my .dll assembly file so that my SQL Server 2005 DB instance can find it? Another way to import the .dll file is to provide the actual byte sequence of the .dll file directly into a CREATE ASSEMBLY command, but I've never tried this... Any help much appreciated. Holf

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

06-14-2007, 11:06 AM	#2
raymondp DiscountASP.NET Staff Join Date: Feb 2006 Posts: 907	Unfortunately this is not allowed with discountasp SQL servers. This will require specific righst to the user that will compromise the entire database server.

06-15-2007, 11:28 AM	#3
Holf Join Date: Jul 2006 Posts: 21	Thanks for the response Raymond. Yes, that is quite understandable and I suspected this would be the case. I guess I'll just have to use good old T-SQL...