I need to run this sql statement: UPDATE sysobjects SET xtype = 'S' WHERE
name = 'dtproperties'

In Sql server 2000 I had to 'Allow modifications to be made directly to the
system catalog'.
How is this done in Sql server 2005?

Thanks,
Søren

Hello,

sysobjects is now a system view. it's no longer system table. Can you tell
me the reason why you need to convert this table into system type.
For all the required system catalogue changes SQL Server 2005 comes with
ALTER commands and system stored procedures.

Thanks
Hari
SQL Server MVP



"Søren Chrsitensen" <xxxx@xxxx.com> wrote in message
news:O0dNcnv2GHA.5016@TK2MSFTNGP02.phx.gbl...
>I need to run this sql statement: UPDATE sysobjects SET xtype = 'S' WHERE
>name = 'dtproperties'
>
> In Sql server 2000 I had to 'Allow modifications to be made directly to
> the system catalog'.
> How is this done in Sql server 2005?
>
> Thanks,
> Søren
>

This is being discussed in the .server newsgroup. Please do not post
independently in multiple newsgroups and people will waste their time
answering questions that have already been answered.

--
HTH
Kalen Delaney, SQL Server MVP


"Søren Chrsitensen" <xxxx@xxxx.com> wrote in message
news:O0dNcnv2GHA.5016@TK2MSFTNGP02.phx.gbl...
>I need to run this sql statement: UPDATE sysobjects SET xtype = 'S' WHERE
>name = 'dtproperties'
>
> In Sql server 2000 I had to 'Allow modifications to be made directly to
> the system catalog'.
> How is this done in Sql server 2005?
>
> Thanks,
> Søren
>