今天创建SQL server2005 程序集时,提示权限失败,我是sa权限。
最后通过 添加如下这句才得以通过
1: ALTER DATABASE [TestDB] SET TRUSTWORTHY ON
完整代码如下:
1: USE [TestDB]
2: GO
3: IF EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'GetImage')
4: DROP ASSEMBLY [ImportMedia]
5:
6: ALTER DATABASE [TestDB] SET TRUSTWORTHY ON
7:
8: CREATE ASSEMBLY GetImageAssem
9: FROM 'C:\GetImage.dll'
10: WITH PERMISSION_SET = EXTERNAL_ACCESS;
11: GO
12:
13: CREATE PROCEDURE DownloadImage
14: (
15: @url nvarchar(200)
16: )
17: AS EXTERNAL NAME
18: GetImageAssem.[GetImage.Down].DownloadImage
19:
20: GO
21:
22: exec DownloadImage 'http://www.hedgate.net/wp-content/uploads/polaroid-chris.png'
分享到:
相关推荐
hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including ...
The authors present "how-to" <br>solutions and never-before-published tips for SQL Server 2005 installation, <br>upgrades, configuration, authoring, schema design, development, deployment, ...
has worked with Sybase and Microsoft SQL Server for more than 23 years and is coauthor of Sybase SQL Server Unleashed, Microsoft SQL Server 2000 Unleashed, and Microsoft SQL Server 2005 Unleashed....
Transact-SQL SQL Server Performance Tuning Tips 用于Sql/Server Transact-Sql优化的教材,很实用。
Top 10 Tips for Optimizing SQL Server Performance
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you’ll learn everything you ...
备份sqlserver数据库为txt,可远程 局域网连接, 导出建表脚本,存储过程脚本,数据脚本(视图等不会导出) 可批量导出,可导出数据量很大的数据库,会自动拆分为多个数据脚本,注意选择完整模式 tips:表要有主键,且主键...
SQL Server 2017 Query Performance Tuning is about more than quick tips and fixes. You’ll learn to be proactive in establishing performance baselines using tools such as Performance Monitor and ...
Builds a strong foundation that gets you comfortable using PowerShell with SQL Server - empowering you to create more complex scripts that you need in your day-to-day job.">Provides over a hundred ...
Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling ...
Understand how to: Master DBA tips, tricks, and best practices proven in actual enterprise environments Install, upgrade or transition to SQL Server 2008. Harden and Secure an implementation. Encrypt...
Pro SQL Server Always On Availability Groups is aimed at SQL Server architects, database administrators, and IT professionals who are tasked with architecting and deploying a high-availability and ...
本文主要分享了FPGA设计小技巧,如何正确使用FPGA的时钟资源,希望对你的学习又说帮助。
Loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, Professional Microsoft SQL Server 2008 Administration is a how-to guide for experienced DBAs....
tips:在win10中查找SQL Server 2016配置管理器,用来开启SQL Server网络配置,启用实例TCP/IP协议和Name PiPe。 Windows 10: 要打开 SQL Server 配置管理器,请在“起始页”中键入 SQLServerManager13.msc(适用于...
《WPF Tips: Uncheckable radio buttons》一文的可执行程序示例与源代码。 原文网址:http://blog.csdn.net/xinyaping/article/details/7887663 作者:辛亚平 工程文件为Visual Studio 2008 with .Net Framework 3.5...
ACCAF5考前Tips:考试重点及答题技巧下.doc
sql server tips word document file for help
Performance Tuning Tips for SQL & PL/SQL