34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE ASSEMBLY SQLCLRTest
FROM N'C:\Users\Administrator\Desktop\SqlServerProject.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Xml;
using System.IO;
using System.Net;
using System.Text;
using System.Threading;
public partial class UserDefinedFunctions {
[Microsoft.SqlServer.Server.SqlFunction]
public static SqlString TESTFunction() {
// 在此处放置代码
return new SqlString( "Hello" );
}
alter database [master] set TRUSTWORTHY on
EXEC sp_changedbowner 'sa'
--启动CLR
exec sp_configure 'show advanced options', '1';
go
reconfigure;
go
exec sp_configure 'clr enabled', '1'
go
reconfigure;
exec sp_configure 'show advanced options', '1';
go
--解决办法
use master
GRANT EXTERNAL ACCESS ASSEMBLY TO Air_User