从 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
AI Hentai Generator
Generate AI Hentai for free.
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
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).
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:
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
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
How to upgrade wps version? How to update the version of wps office?
Mar 14, 2024 am 08:43 AM
WPS is a must-have computer software for many users. Regular updates to new versions can allow users to get a better user experience and more features. So how to upgrade the wps version? There are three main methods for upgrading wpsoffice. Let’s take a look below. Method 1: Download the new version from the official website You can download the latest version of the installation package from the WPSOffice official website. After entering the WPSOffice official website (https://www.wps.cn/), click the "Download" button, select the version you need to download, and then follow the prompts to install it. Note: When installing a new version, you need to uninstall the old version, otherwise it will cause software conflicts and prevent normal use. Method 2: In WPSOf
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.
DualBEV: significantly surpassing BEVFormer and BEVDet4D, open the book!
Mar 21, 2024 pm 05:21 PM
This paper explores the problem of accurately detecting objects from different viewing angles (such as perspective and bird's-eye view) in autonomous driving, especially how to effectively transform features from perspective (PV) to bird's-eye view (BEV) space. Transformation is implemented via the Visual Transformation (VT) module. Existing methods are broadly divided into two strategies: 2D to 3D and 3D to 2D conversion. 2D-to-3D methods improve dense 2D features by predicting depth probabilities, but the inherent uncertainty of depth predictions, especially in distant regions, may introduce inaccuracies. While 3D to 2D methods usually use 3D queries to sample 2D features and learn the attention weights of the correspondence between 3D and 2D features through a Transformer, which increases the computational and deployment time.
How to upgrade Xiaomi 14Pro to ThePaper OS?
Mar 18, 2024 pm 07:34 PM
Mi 14 Pro is Xiaomi's latest flagship phone, and ThePaper OS is a new operating system independently developed by Xiaomi, dedicated to providing a smoother and smarter user experience. With the continuous development of technology, ThePaper OS is also constantly being updated and upgraded. So many users who are using Xiaomi mobile phones for the first time are asking Xiaomi 14Pro users how to upgrade ThePaper OS? How to upgrade Xiaomi Mi 14 Pro to Thermal OS? There is no need to update. The original factory comes with Thermal OS. How to update other models that support ThePaper OS: 1. Open the settings application of your phone and find the system update option. 2. The system will automatically detect the current system version and prompt when a new version is available for update. 3. Just click "Update Now" and the system will start downloading automatically.
