Tuesday, November 08, 2005

Re: Ad hoc updates to system catalogs are not allowed. - MSDN:

"sp_configure 'allow updates', 1

reconfigure with override

update sysobjects set status = 0xc0000001 where name = 'sp_name'

sp_configure 'allow updates', 0"

0 Comments:

Post a Comment

<< Home