sql2000语句在SQL2005下出现错误?

[xwqjamky]

sp_configure 'Allow Update', 1
RECONFIGURE with override
go

declare @id varbinary(300)
use master
select @id=sid from sysusers where name='ERP'
--copy sid
use ERPDATA
update sysusers set sid=@id where name='ERP'
GO

sp_configure 'Allow Update', 0
RECONFIGURE with override

以上的语句在SQL2000SP4下运行正常,但在SQL2005下执行错误,该如何做这些操作呢?

[xwqjamky]

顶顶,谁能告诉我怎样修改系统表

[yesyesyes]

sqlserver2005已经不允许修改系统表了

[xwqjamky]

有其它办法可以修改系统表吗?

[xwqjamky]

use master
select @id=sid from sysusers where name='ERP'
--copy sid
use ERPDATA
update sysusers set sid=@id where name='ERP'


怎样做这样的操作呢?

[feixiangVB]

關注~~~

[伴老思源]

关注

[伴老思源]

http://forums.microsoft.com/MSDN-CHT/ShowPost.aspx?PostID=466368&SiteID=14