Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hummy
Starting Member
32 Posts |
 Posted - 2007-04-03 : 12:16:12
|
| Hi All,I have 2 machines both with SQL Server 2000 and one has SP3a and one has SP4. I am getting error messages on editing the maintenance plans.I have 3a installed on both machines but upgraded 1 to SP45 thinking that this was the problem but still get the same message. On machine with 3A upon exiting the plan i get the message:"Error 150: [SQL-DMO] Code Execution Exception. EXCEPTION_PRIV_INSTRUCTION"On the machine i have SP4 i have a different problem. Machine was on SQL 2000 SP3a and upgraded to 4 to see if it resolved the issue but still results in same error below:"An unhandled win32 exception occured in mmc.exe[23528]. Just-in-time debugging thie exception failed with the following error: No installed debugger has Just-In-Time debugging enabled. In Visual Studio, Just-In-Time debugging can be enabled from Tools/Options/Debugging/Just-In-Time."on some initial searching for the second error it sugests that it could be related to having a development environment installed. But there has never been or there is no development environment set up here. Any one have any ideas?Thanks in Advance. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-03 : 13:51:08
|
| Is the database running under MSDE? We had some problems with the Hours/Days/Weeks/etc. DropDowns being blank on MSDE, and consequently not transferring that parameter to the SQLMaint routine.If its not that then please ignore!Kristen |
 |
|
|
|
|
|
Error obtained editing maintenance plans