You need to to set the server option 'allow updates'; you can run
sp_configure to do this from query analyser. You can also use Enterprise
Manager - right click the relevant server, select Properties and then the
Server Settings tab.

> -----Original Message-----
> From: Shawn Smith (William) [SMTP:[Email Address Removed] Sent: Wednesday, February 27, 2002 10:01 PM
> To: '[Email Address Removed] Subject: Ad Hoc Update error
>
> When running the following I get an error message below:
> update sysxlogins set dbid=6 where dbid=1 and name <> 'sa'
>
> Error: Ad hoc updates to system catalogs are not enabled. The system
> administrator must reconfigure SQL Server to allow this.
>
> How do I enable Ad hoc updates?
>
> Shawn Smith
> Database Administrator
> Fort Worth Star-Telegram
> 817-390-7094
> 817-291-5240 cell
> 817-667-2757 pager
> [Email Address Removed]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page