sql 中锁定的存储过程
我对sql server 2005不太熟悉。
我在sql中有一个模式，其中包含带有小锁的存储过程。据我了解，它们是使用 C# 创建的，所有这些锁定程序都有一个 C# 源文件，其中包含程序代码。问题是我无法访问它们。我需要修改其中一个程序，但它不允许我修改它们。我有这些过程的源代码（来自 Visual Studio），但是当我更改代码中的某些内容时，它不会影响 sql 中的过程。
如何更改 sql server 2005 中程序集的路径？还有其他方法可以访问这些存储过程吗？
提前致谢，
格雷格
I am not too familiar with sql server 2005.
I have a schema in sql which has stored procedures with small lock on them. As I understand they were created using C#, all these locked procedures have a source file in C# with the code of the procedures. The thing is I can't access them. I need to modify one of these procedures but it doesn't let me modify them. I have the source code (from visual studio) with these procedures but when I change something in the code, it doesn't affect the procedures in the sql.
How can I change the path to assembly in sql server 2005? Is there any other way I can access these stored procedures?
Thanks in advance,
Greg
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您编辑的SQL脚本必须应用到数据库才能生效。
您可以使用 SQL Server Management Studio 中的查询窗口或通过从数据库项目部署脚本来执行此操作。
The SQL scripts that you edit must be applied to the database before they will take effect.
You can do this with a query window from SQL Server Management Studio, or by deploying the script from a database project.
如果这些是 CLR 存储过程，并且您已更改源并重新编译新的 DLL，则需要将新的 DLL 部署到数据库。您无法“更改程序集的路径”，因为它不是从文件系统加载 DLL，而是存储在数据库中。您需要更新数据库中的程序集，为此运行以下脚本，将相关位替换为程序集详细信息：
If these are CLR stored procedures and you have changed the source and recompiled a new DLL then you need to deploy the new DLL to the database. You cannot "change the path" to the assembly as it is not loading the DLL from the file system, it is stored in the database. You need to update the assembly in the database, to do that run the following script replacing the relevent bits with your assembly details: