从 SQL Server 2005 Beta 2 升级到 SQL Server 2005 社区技术预
1.症状 从 Microsoft SQL Server 2005 Beta 2 升级到 Microsoft SQL Server 2005 社区技术预览 (CTP) 后，无法运行所有 SQL Server 代理作业。 此外，SQL Server 代理错误日志中都记录在以下的错误信息： 子系统不能加载 ActiveScripting （原因： 找不到指
1.症状
从 Microsoft SQL Server 2005 Beta 2 升级到 Microsoft SQL Server 2005 社区技术预览 (CTP) 后，无法运行所有 SQL Server 代理作业。 此外，SQL Server 代理错误日志中都记录在以下的错误信息：
子系统不能加载 ActiveScripting （原因： 找不到指定的模块）
无法加载子系统 CmdExec （原因： 找不到指定的模块）
无法加载子系统快照 （原因： 找不到指定的模块）
无法加载子系统日志读取器 (原因： 找不到指定的模块）
无法加载子系统分发 （原因： 找不到指定的模块）
无法加载合并的子系统 (原因： 找不到指定的模块）
无法加载子系统 QueueReader （原因： 找不到指定的模块）
子系统不能加载 ANALYSISQUERY （原因： 找不到指定的模块）
无法加载子系统 ANALYSISCOMMAND （原因： 找不到指定的模块）
无法加载子系统 dts （原因： 找不到指定的模块）
请注意 只有当您执行安装 SQL Server 2005 CTP 组件一起使用使用现有的数据选项的安装升级时才会出现此问题。
2.原因
因为二进制文件的位置已更改 SQL Server 2005 CTP 中出现此问题。
3.解决方案
若要解决此问题，更新指向正确的位置，每个子系统的 msdb.dbo.syssubsystems 系统表中包含的子系统元数据。
默认， subsystem_dll 数据列和 agent_exe 数据列应具有下列值为每个子系统。
收起该表格展开该表格
| 子系统 | subsystem_dll | agent_exe |
|---|---|---|
| ActiveScripting | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlatxss90.dll | NULL |
| CmdExec | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlcmdss90.dll | NULL |
| 快照 | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlrepss90.dll | C: / Program Files /Microsoft SQL Server/90/COM/Snapshot.exe |
| 日志读取器 | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlrepss90.dll | C: / Program Files /Microsoft SQL Server/90/COM/Logread.exe |
| 通讯组 | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlrepss90.dll | C: / Program Files /Microsoft SQL Server/90/COM/Distrib.exe |
| 合并 | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlrepss90.dll | C: / Program Files /Microsoft SQL Server/90/COM/Replmerg.exe |
| QueueReader | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlrepss90.dll | C: / Program Files /Microsoft SQL Server/90/COM/Qrdrsvc.exe |
| ANALYSISQUERY | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlolapss90.dll | NULL |
| ANALYSISCOMMAND | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqlolapss90.dll | NULL |
| dts | C: / Program Files /Microsoft SQL Server/MSSQL.1/MSSQL/binn/Sqldtsss90.dll | C: / Program Files /Microsoft SQL Server/90/DTS/binn/Dtexec.exe |
请注意 在更新数据列之后，您必须重新启动 SQL Server 代理服务。
FROM :http://support.microsoft.com/?kbid=903205
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1669
14
1428
52
1329
25
1273
29
1256
24
What is the difference between HQL and SQL in Hibernate framework?
Apr 17, 2024 pm 02:57 PM
HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).
Xiaoyi upgraded to an intelligent agent! HarmonyOS NEXT Hongmeng native intelligence opens a new AI era
Jun 22, 2024 am 01:56 AM
On June 21, Huawei Developer Conference 2024 (HDC2024) gathered again in Songshan Lake, Dongguan. At this conference, the most eye-catching thing is that HarmonyOSNEXT officially launched Beta for developers and pioneer users, and comprehensively demonstrated the three "king-breaking" innovative features of HarmonyOSNEXT in all scenarios, native intelligence and native security. HarmonyOSNEXT native intelligence: Opening a new AI era After abandoning the Android framework, HarmonyOSNEXT has become a truly independent operating system independent of Android and iOS, which can be called an unprecedented rebirth. Among its many new features, native intelligence is undoubtedly the new feature that can best bring users intuitive feelings and experience upgrades.
Tutorial on how to solve the problem of being unable to access the Internet after upgrading win10 system
Mar 27, 2024 pm 02:26 PM
1. Use the win+x shortcut key to open the menu and select [Command Prompt (Administrator) (A)], as shown below: 2. After entering the command prompt interface, enter the [ipconfig/flushdns] command and press Enter , as shown in the figure below: 3. Then enter the [netshwinsockresetcatalog] command and press Enter, as shown in the figure below: 4. Finally enter the [netshintipreset] command and press Enter, restart the computer and you can access the Internet, as shown in the figure below:
Google app beta APK teardown reveals new extensions coming to Gemini AI assistant
Jul 30, 2024 pm 01:06 PM
Google's AI assistant, Gemini, is set to become even more capable, if the APK teardown of the latest update (v15.29.34.29 beta) is to be considered. The tech behemoth's new AI assistant could reportedly get several new extensions. These extensions wi
I upgraded arise account registration by myself and shared graphic tutorials
Mar 28, 2024 pm 01:16 PM
How do I register an account when I upgrade arise alone? I Upgrade Arise Alone is an action-adventure RPG adapted from the popular comic book of the same name. Currently, the game has started external testing. Many players want to experience it. Here is an introduction to how to register a game account. I hope it will be helpful to everyone. [Registration Method] To register an account, you can choose Google, Apple or email to log in. It is recommended that players choose to register with an email account. [Detailed steps] 1. First, select the last email address in the account binding interface to log in, then jump to the email registration interface, and directly click the email address in the picture below to register. 2. After entering the registration email page, enter the email number, set the login password and click Next. 3. Then bind the recovery email. The function of the recovery email: you can use the email recovery function after the account is lost.
The best time to buy Huawei Mate 60 series, new AI elimination + image upgrade, and enjoy autumn promotions
Aug 29, 2024 pm 03:33 PM
Since the Huawei Mate60 series went on sale last year, I personally have been using the Mate60Pro as my main phone. In nearly a year, Huawei Mate60Pro has undergone multiple OTA upgrades, and the overall experience has been significantly improved, giving people a feeling of being constantly new. For example, recently, the Huawei Mate60 series has once again received a major upgrade in imaging capabilities. The first is the new AI elimination function, which can intelligently eliminate passers-by and debris and automatically fill in the blank areas; secondly, the color accuracy and telephoto clarity of the main camera have been significantly upgraded. Considering that it is the back-to-school season, Huawei Mate60 series has also launched an autumn promotion: you can enjoy a discount of up to 800 yuan when purchasing the phone, and the starting price is as low as 4,999 yuan. Commonly used and often new products with great value
Detailed explanation of how to upgrade Honor mobile phones to Hongmeng system
Mar 25, 2024 am 11:51 AM
In a new technological field, new operating systems always attract much attention. Recently, Honor mobile phones announced that they will be upgraded to Hongmeng OS, a new operating system developed by Huawei. This is undoubtedly good news for many Honor mobile phone users. However, many users may still have doubts about how to upgrade to Hongmeng system. This article will explain in detail how to upgrade Honor mobile phones to Hongmeng system to help users better understand and operate it. First of all, to upgrade an Honor phone to the Hongmeng system, users need to ensure that the phone is connected to the network and has sufficient power. this
Review! Deep model fusion (LLM/basic model/federated learning/fine-tuning, etc.)
Apr 18, 2024 pm 09:43 PM
In September 23, the paper "DeepModelFusion:ASurvey" was published by the National University of Defense Technology, JD.com and Beijing Institute of Technology. Deep model fusion/merging is an emerging technology that combines the parameters or predictions of multiple deep learning models into a single model. It combines the capabilities of different models to compensate for the biases and errors of individual models for better performance. Deep model fusion on large-scale deep learning models (such as LLM and basic models) faces some challenges, including high computational cost, high-dimensional parameter space, interference between different heterogeneous models, etc. This article divides existing deep model fusion methods into four categories: (1) "Pattern connection", which connects solutions in the weight space through a loss-reducing path to obtain a better initial model fusion
