SQLCLR错误

今天终于不要加班了 2011-10-11 04:58:35

我在SQL2005还原数据库到SQL2008R2，原数据库中带有CLR函数，原本一切OK，但是发现每隔一天C#中调用CLR函数后的ChargeDirection=ReturnValue的值均为NULL，而到数据库中执行CLR的返回值为正常，必须重启SQL或者服务才行，然后隔一天又会出现此问题，请教下有没有设置一类的问题或是需要注意的地方。

...全文

69 4 打赏收藏转发到动态举报

写回复

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

唐诗三百首 2011-10-13

打赏
举报

回复

"SQL2005还原数据库到SQL2008R2"

数据库的兼容等级应该是90吧,修改为100试试.

Lemon2050 2011-10-11

打赏
举报

回复

建议你查看下系统的log，或者sql的log，很可能是有什么服务停止了，你看看都有什么服务和sql相关的。因为你重启就好了，所以我觉得应该是其他dependency的服务出问题了。
1.找到是什么服务导致你c#取不到值
2.为什么这个服务会出问题
3.fix
4.验证已经fixed

今天终于不要加班了 2011-10-11

打赏
举报

回复

图片没出来..
http://hi.csdn.net/space-8588532-do-album-picid-943187.html
http://hi.csdn.net/space-8588532-do-album-picid-943187-goto-down.html
这里有2张图片，显示CLR在不同环境下执行的错误

今天终于不要加班了 2011-10-11

打赏
举报

回复

正则表达式包装器 SQLCLR 包装类 System.Text.RegularExpressions.Regex 查看更多详情

本书《精通SQL Server 2008开发》深入探讨了SQL Server 2008的高级特性和最佳实践，旨在帮助读者掌握数据库开发的核心技能。书中涵盖了数据库编程的最佳实践、错误和异常处理、权限和授权、加密技术等关键主题。此外，还详细介绍了动态T-SQL、SQLCLR集成、空间数据处理、时间数据管理以及树形和层次结构数据的处理方法。通过实例和实战经验，作者帮助读者理解如何在实际项目中应用这些技术和方法，提高系统的性能和安全性。无论是新手还是有经验的开发人员，都能从中受益匪浅。

数据库升级后，低版本数据库备份文件还原到高版本数据库后，提示数据库不可信的解决方式

我觉得很好的新特性带来啦非常高的价值

中文名: SQL Server 2008 R2详解手册原名: Microsoft SQL Server 2008 R2 Unleashed 作者: Ray Rankins Paul Bertucci Chris Gallelli Alex T.Silverstein 资源格式: PDF 版本: 影印版出版社: Sams书号: 978-0672330568发行时间: 2010年09月26日地区: 美国语言: 英文简介: 内容简介: Microsoft SQL Server 2008 R2 Unleashed includes full coverage of SQL Server 2008 in addition to R2 coverage This is the industry the most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product most complex and powerful capabilities, and its newest tools and features. For example, you will find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance. The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value. * Understand the Microsoft SQL Server 2008 environment, R2 for newest features, and each edition capabilities * Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell * Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects from tables and indexes to stored procedures and triggers * Increase availability with clustering, database mirroring, and other features * Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization * Use SQL Server Profiler to capture queries and identify bottlenecks * Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor * Develop applications using SQL Server 2008 enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery 作者介绍: Ray Rankins, president of Gotham Consulting Services, 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. Paul Bertucci, founder of Database Architechs, has more than 30 years of experience in database design, architecture, replication, tuning, integration, and high availability. Chris Gallelli, president of CGAL Consulting Services, specializes in database administration, tuning, and programming. Alex T. Silverstein is managing principal and chief architect of Unified Digital Group, LLC, a developer of custom SQL Server and Microsoft .NET solutions. 目录: Introduction Part I Welcome to Microsoft SQL Server 1. SQL Serve 2008 Overview 2. What’s new in SQL Serve 2008 3. Examples of SQL Server Implementations Part II SQL Server Tools and Utilities 4. SQL Server Management Studio 5. SQL Server Command-Line Utilities 6. SQL Server Profiler Part III SQL Server Administration 7. SQL Server System and Database Administration 8. Installing SQL Serve 2008 9. Upgrading to SQL Serve 2008 10. Client Installation and Configuration 11. Security and User Administration ………

27,581

社区成员

68,548

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章