我看了大家给的链接,但我看了发现还是不太明白. 我的Windows 2003 SP2, SQL2005 SP2 SQL2005 版本是: Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 为什么就是不行呢? 请再指教,谢谢!
貌似2005不允许更改'allow updates'属性
试试将allow updates改为0先.
这个选项并不存在,请检查核实:'Database mail XPs'
reconfigure go 执行出错如下: Msg 5808, Level 16, State 1, Line 1 Ad hoc update to system catalogs is not supported. exec sp_configure 'Database mail XPs',1 go执行出错为: Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option 'Database mail XPs' does not exist, or it may be an advanced option.
exec sp_configure 'show advanced options',1 go 我改为 exec sp_configure 'show advanced options',0 go 也试过了! 反正后面的还是不行! 仍然出错. 到底要在哪里解决呢? 对了我的SQL2005 是装的STANDARD版本的.
allow updates Option: This option is still present in the sp_configure stored procedure, although its functionality is unavailable in Microsoft SQL Server 2005 (the setting has no effect). In SQL Server 2005, direct updates to the system tables are not supported.2005不允许修改系统表。所以'allow updates'无法开启,那么相关的选项就都不能用了……
‘allow updates'系统默认值是0……
exec sp_configure 'allow updates',0 reconfigure go这样改了后,不出错了! 但后面的 exec sp_configure 'Database mail XPs',1 go 仍然出错如下: Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51 The configuration option 'Database mail XPs' does not exist, or it may be an advanced option. 非常谢谢lingCK大侠, 请再帮帮!
exec sp_configure 'show advanced options',1 go reconfigure go exec sp_configure 'Database Mail XPs',1 go reconfigure go
根本没解决问题啊,关键是'Database mail XPs' ,MSSQL05不认识啊。
exec sp_configure 'show advanced options',1 go reconfigure go exec sp_configure 'Database Mail XPs',1 go reconfigure go 非常谢谢lingck大侠,确实可以了!
我的Windows 2003 SP2, SQL2005 SP2
SQL2005 版本是:
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 为什么就是不行呢? 请再指教,谢谢!
reconfigure
go
执行出错如下:
Msg 5808, Level 16, State 1, Line 1
Ad hoc update to system catalogs is not supported.
exec sp_configure 'Database mail XPs',1
go执行出错为:
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'Database mail XPs' does not exist, or it may be an advanced option.
go 我改为
exec sp_configure 'show advanced options',0
go 也试过了! 反正后面的还是不行! 仍然出错.
到底要在哪里解决呢?
对了我的SQL2005 是装的STANDARD版本的.
1.allow updates为1时,Reconfigure无效..先将allow updates更改为0.
This option is still present in the sp_configure stored procedure, although its functionality is unavailable in Microsoft SQL Server 2005 (the setting has no effect). In SQL Server 2005, direct updates to the system tables are not supported.2005不允许修改系统表。所以'allow updates'无法开启,那么相关的选项就都不能用了……
reconfigure
go这样改了后,不出错了! 但后面的
exec sp_configure 'Database mail XPs',1
go
仍然出错如下:
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'Database mail XPs' does not exist, or it may be an advanced option.
非常谢谢lingCK大侠, 请再帮帮!
go
reconfigure
go
exec sp_configure 'Database Mail XPs',1
go
reconfigure
go
go
reconfigure
go
exec sp_configure 'Database Mail XPs',1
go
reconfigure
go
非常谢谢lingck大侠,确实可以了!