從 SQL Server 2005 Beta 2 升級到 SQL Server 2005 社區(qū)技術預
Jun 07, 2016 pm 03:48 PM1.癥狀 從 Microsoft SQL Server 2005 Beta 2 升級到 Microsoft SQL Server 2005 社區(qū)技術預覽 (CTP) 后,無法運行所有 SQL Server 代理作業(yè)。 此外,SQL Server 代理錯誤日志中都記錄在以下的錯誤信息: 子系統(tǒng)不能加載 ActiveScripting (原因: 找不到指
1.癥狀?
從 Microsoft SQL Server 2005 Beta 2 升級到 Microsoft SQL Server 2005 社區(qū)技術預覽 (CTP) 后,無法運行所有 SQL Server 代理作業(yè)。 此外,SQL Server 代理錯誤日志中都記錄在以下的錯誤信息:
子系統(tǒng)不能加載 ActiveScripting (原因: 找不到指定的模塊)
無法加載子系統(tǒng) CmdExec (原因: 找不到指定的模塊)
無法加載子系統(tǒng)快照 (原因: 找不到指定的模塊)
無法加載子系統(tǒng)日志讀取器 (原因: 找不到指定的模塊)
無法加載子系統(tǒng)分發(fā) (原因: 找不到指定的模塊)
無法加載合并的子系統(tǒng) (原因: 找不到指定的模塊)
無法加載子系統(tǒng) QueueReader (原因: 找不到指定的模塊)
子系統(tǒng)不能加載 ANALYSISQUERY (原因: 找不到指定的模塊)
無法加載子系統(tǒng) ANALYSISCOMMAND (原因: 找不到指定的模塊)
無法加載子系統(tǒng) dts (原因: 找不到指定的模塊)
請注意 只有當您執(zhí)行安裝 SQL Server 2005 CTP 組件一起使用使用現(xiàn)有的數(shù)據(jù)選項的安裝升級時才會出現(xiàn)此問題。
?
2.原因?
因為二進制文件的位置已更改 SQL Server 2005 CTP 中出現(xiàn)此問題。
3.解決方案
若要解決此問題,更新指向正確的位置,每個子系統(tǒng)的 msdb.dbo.syssubsystems 系統(tǒng)表中包含的子系統(tǒng)元數(shù)據(jù)。
默認, subsystem_dll 數(shù)據(jù)列和 agent_exe 數(shù)據(jù)列應具有下列值為每個子系統(tǒng)。
收起該表格展開該表格
子系統(tǒng) | 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 |
請注意 在更新數(shù)據(jù)列之后,您必須重新啟動 SQL Server 代理服務。
FROM :http://support.microsoft.com/?kbid=903205

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

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

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

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.

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

Written above & The author’s personal understanding is that image-based 3D reconstruction is a challenging task that involves inferring the 3D shape of an object or scene from a set of input images. Learning-based methods have attracted attention for their ability to directly estimate 3D shapes. This review paper focuses on state-of-the-art 3D reconstruction techniques, including generating novel, unseen views. An overview of recent developments in Gaussian splash methods is provided, including input types, model structures, output representations, and training strategies. Unresolved challenges and future directions are also discussed. Given the rapid progress in this field and the numerous opportunities to enhance 3D reconstruction methods, a thorough examination of the algorithm seems crucial. Therefore, this study provides a comprehensive overview of recent advances in Gaussian scattering. (Swipe your thumb up

The GPT-4o model released by OpenAI is undoubtedly a huge breakthrough, especially in its ability to process multiple input media (text, audio, images) and generate corresponding output. This ability makes human-computer interaction more natural and intuitive, greatly improving the practicality and usability of AI. Several key highlights of GPT-4o include: high scalability, multimedia input and output, further improvements in natural language understanding capabilities, etc. 1. Cross-media input/output: GPT-4o+ can accept any combination of text, audio, and images as input and directly generate output from these media. This breaks the limitation of traditional AI models that only process a single input type, making human-computer interaction more flexible and diverse. This innovation helps power smart assistants

Apple announced its Apple Intelligence features back in June, and they initially made an appearance in the latest iOS 18 beta versions for the iPhone 15 Pro models and any iPad or Mac with an M1 SoC or newer. However, there have been a few location-r

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

As a data professional, you need to process large amounts of data from various sources. This can pose challenges to data management and analysis. Fortunately, two AWS services can help: AWS Glue and Amazon Athena.
