Error_259 "Ad Hoc Update error"

  • If u Find this Problem/Error Message 259

    Solution is as Under.

    Use

    Enterprise Manager--------> Right click on Server Name

    Select Properties----------> Server Settings Tab.

    Check on this option

    Allow modifications to be made directly to the system catalogs.

    Or Run this Command

    sp_configure 'allow updates',1

     

  • Hi,

    DBA what u want , ur new research on sql.

    or u want to ask something else

    from

    killer

     

  • Dude you are allowing anyone to write anything they want to the system tables by doing that. You should NEVER do that permenantly (and rarely, shortly for some DBA tasks)...

  • One more thing to consider... you can always have sql injection attacks use this to their advantage, never forget that threat, ever.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply