"Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
news:EAA6BCF7-ED40-41EF-9968-AB473829DBD8@microsoft.com...
> Hi
>
> SQL Server 2005 Express.
> 25 january 2007 I added a new procedure to my database using ole automation
> procedures such as sp_OACreate and sp_OAMethod.
>
> These system procedures requires 'Ole Automation Procedures' to be enabled.
> So I added the following to my installation script:
> sp_configure 'show advanced options', 1;
> GO
> RECONFIGURE;
> GO
> sp_configure 'Ole Automation Procedures', 1;
> GO
> RECONFIGURE;
> GO
>
> The script run fine and my procedue also runs fine.
>
> But suddenly today installaing a new database I get an error mesage:
> "Ad hoc update to system catalogs is not supported"
> when I run the commands above.
> Does anyone now what has happend since january?  I installed a SP2 of SQL
> Server Express.  Has there been any changes?
>
> Running "reconfigure with override" works but it is not recommended to use
> "with override" I have read.
>
> Is there any other way of enabling 'Ole Automation Procedures' which is
> allowed?
>
> Help is appreciated.
>
> Regards Kjell Arne Johansen
>
>
>

"Tibor Karaszi" wrote:

> We need to know what or who is trying to modify the system tables. Without seeing any code, we can't
> say where the problem it. My guess is that you instantiate a COM object, which in turn connect back
> to SQL Server and try to modify the system table - something you cannot do in 2005.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
> news:EAA6BCF7-ED40-41EF-9968-AB473829DBD8@microsoft.com...
> > Hi
> >
> > SQL Server 2005 Express.
> > 25 january 2007 I added a new procedure to my database using ole automation
> > procedures such as sp_OACreate and sp_OAMethod.
> >
> > These system procedures requires 'Ole Automation Procedures' to be enabled.
> > So I added the following to my installation script:
> > sp_configure 'show advanced options', 1;
> > GO
> > RECONFIGURE;
> > GO
> > sp_configure 'Ole Automation Procedures', 1;
> > GO
> > RECONFIGURE;
> > GO
> >
> > The script run fine and my procedue also runs fine.
> >
> > But suddenly today installaing a new database I get an error mesage:
> > "Ad hoc update to system catalogs is not supported"
> > when I run the commands above.
> > Does anyone now what has happend since january?  I installed a SP2 of SQL
> > Server Express.  Has there been any changes?
> >
> > Running "reconfigure with override" works but it is not recommended to use
> > "with override" I have read.
> >
> > Is there any other way of enabling 'Ole Automation Procedures' which is
> > allowed?
> >
> > Help is appreciated.
> >
> > Regards Kjell Arne Johansen
> >
> >
> >
>
>
>

"Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
news:AC5E975F-39E6-482A-9C1D-700C613AA3C6@microsoft.com...
> Hi
>
> This is the code causing the error message to occur when it is executed.
> A month ago it worked fine.
>
> sp_configure 'show advanced options', 1;
> GO
> RECONFIGURE;
> GO
> sp_configure 'Ole Automation Procedures', 1;
> GO
> RECONFIGURE;
> GO
>
>
> Regards Kjell Arne Johansen
>
> "Tibor Karaszi" wrote:
>
>> We need to know what or who is trying to modify the system tables. Without seeing any code, we
>> can't
>> say where the problem it. My guess is that you instantiate a COM object, which in turn connect
>> back
>> to SQL Server and try to modify the system table - something you cannot do in 2005.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
>> news:EAA6BCF7-ED40-41EF-9968-AB473829DBD8@microsoft.com...
>> > Hi
>> >
>> > SQL Server 2005 Express.
>> > 25 january 2007 I added a new procedure to my database using ole automation
>> > procedures such as sp_OACreate and sp_OAMethod.
>> >
>> > These system procedures requires 'Ole Automation Procedures' to be enabled.
>> > So I added the following to my installation script:
>> > sp_configure 'show advanced options', 1;
>> > GO
>> > RECONFIGURE;
>> > GO
>> > sp_configure 'Ole Automation Procedures', 1;
>> > GO
>> > RECONFIGURE;
>> > GO
>> >
>> > The script run fine and my procedue also runs fine.
>> >
>> > But suddenly today installaing a new database I get an error mesage:
>> > "Ad hoc update to system catalogs is not supported"
>> > when I run the commands above.
>> > Does anyone now what has happend since january?  I installed a SP2 of SQL
>> > Server Express.  Has there been any changes?
>> >
>> > Running "reconfigure with override" works but it is not recommended to use
>> > "with override" I have read.
>> >
>> > Is there any other way of enabling 'Ole Automation Procedures' which is
>> > allowed?
>> >
>> > Help is appreciated.
>> >
>> > Regards Kjell Arne Johansen
>> >
>> >
>> >
>>
>>
>>

"Tibor Karaszi" wrote:

> Are you saying that below code, in itself, generates the error you posted? I just tried on my sp2
> with GDR, no error message...
>
> sp_configure 'show advanced options', 1;
> GO
> RECONFIGURE;
> GO
> sp_configure 'Ole Automation Procedures', 1;
> GO
> RECONFIGURE;
> GO
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
> news:AC5E975F-39E6-482A-9C1D-700C613AA3C6@microsoft.com...
> > Hi
> >
> > This is the code causing the error message to occur when it is executed.
> > A month ago it worked fine.
> >
> > sp_configure 'show advanced options', 1;
> > GO
> > RECONFIGURE;
> > GO
> > sp_configure 'Ole Automation Procedures', 1;
> > GO
> > RECONFIGURE;
> > GO
> >
> >
> > Regards Kjell Arne Johansen
> >
> > "Tibor Karaszi" wrote:
> >
> >> We need to know what or who is trying to modify the system tables. Without seeing any code, we
> >> can't
> >> say where the problem it. My guess is that you instantiate a COM object, which in turn connect
> >> back
> >> to SQL Server and try to modify the system table - something you cannot do in 2005.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
> >> news:EAA6BCF7-ED40-41EF-9968-AB473829DBD8@microsoft.com...
> >> > Hi
> >> >
> >> > SQL Server 2005 Express.
> >> > 25 january 2007 I added a new procedure to my database using ole automation
> >> > procedures such as sp_OACreate and sp_OAMethod.
> >> >
> >> > These system procedures requires 'Ole Automation Procedures' to be enabled.
> >> > So I added the following to my installation script:
> >> > sp_configure 'show advanced options', 1;
> >> > GO
> >> > RECONFIGURE;
> >> > GO
> >> > sp_configure 'Ole Automation Procedures', 1;
> >> > GO
> >> > RECONFIGURE;
> >> > GO
> >> >
> >> > The script run fine and my procedue also runs fine.
> >> >
> >> > But suddenly today installaing a new database I get an error mesage:
> >> > "Ad hoc update to system catalogs is not supported"
> >> > when I run the commands above.
> >> > Does anyone now what has happend since january?  I installed a SP2 of SQL
> >> > Server Express.  Has there been any changes?
> >> >
> >> > Running "reconfigure with override" works but it is not recommended to use
> >> > "with override" I have read.
> >> >
> >> > Is there any other way of enabling 'Ole Automation Procedures' which is
> >> > allowed?
> >> >
> >> > Help is appreciated.
> >> >
> >> > Regards Kjell Arne Johansen
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>

"Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in
message news:07F98FD2-5464-4F0D-ACEC-8FC4CF604FD2@microsoft.com...
> Yes you are right.
>
> The command RECONFIGURE causes this error to occur while RECONFIGURE WITH
> OVERRIDE works fine.
>
> Regards Kjell Arne Johansen
>
> "Tibor Karaszi" wrote:
>
>> Are you saying that below code, in itself, generates the error you
>> posted? I just tried on my sp2
>> with GDR, no error message...
>>
>> sp_configure 'show advanced options', 1;
>> GO
>> RECONFIGURE;
>> GO
>> sp_configure 'Ole Automation Procedures', 1;
>> GO
>> RECONFIGURE;
>> GO
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote
>> in message
>> news:AC5E975F-39E6-482A-9C1D-700C613AA3C6@microsoft.com...
>> > Hi
>> >
>> > This is the code causing the error message to occur when it is
>> > executed.
>> > A month ago it worked fine.
>> >
>> > sp_configure 'show advanced options', 1;
>> > GO
>> > RECONFIGURE;
>> > GO
>> > sp_configure 'Ole Automation Procedures', 1;
>> > GO
>> > RECONFIGURE;
>> > GO
>> >
>> >
>> > Regards Kjell Arne Johansen
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> We need to know what or who is trying to modify the system tables.
>> >> Without seeing any code, we
>> >> can't
>> >> say where the problem it. My guess is that you instantiate a COM
>> >> object, which in turn connect
>> >> back
>> >> to SQL Server and try to modify the system table - something you
>> >> cannot do in 2005.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com>
>> >> wrote in message
>> >> news:EAA6BCF7-ED40-41EF-9968-AB473829DBD8@microsoft.com...
>> >> > Hi
>> >> >
>> >> > SQL Server 2005 Express.
>> >> > 25 january 2007 I added a new procedure to my database using ole
>> >> > automation
>> >> > procedures such as sp_OACreate and sp_OAMethod.
>> >> >
>> >> > These system procedures requires 'Ole Automation Procedures' to be
>> >> > enabled.
>> >> > So I added the following to my installation script:
>> >> > sp_configure 'show advanced options', 1;
>> >> > GO
>> >> > RECONFIGURE;
>> >> > GO
>> >> > sp_configure 'Ole Automation Procedures', 1;
>> >> > GO
>> >> > RECONFIGURE;
>> >> > GO
>> >> >
>> >> > The script run fine and my procedue also runs fine.
>> >> >
>> >> > But suddenly today installaing a new database I get an error mesage:
>> >> > "Ad hoc update to system catalogs is not supported"
>> >> > when I run the commands above.
>> >> > Does anyone now what has happend since january?  I installed a SP2
>> >> > of SQL
>> >> > Server Express.  Has there been any changes?
>> >> >
>> >> > Running "reconfigure with override" works but it is not recommended
>> >> > to use
>> >> > "with override" I have read.
>> >> >
>> >> > Is there any other way of enabling 'Ole Automation Procedures' which
>> >> > is
>> >> > allowed?
>> >> >
>> >> > Help is appreciated.
>> >> >
>> >> > Regards Kjell Arne Johansen
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

"Jasper Smith" <jasper_smi***@hotmail.com> wrote in message
news:OumUYWcgHHA.4900@TK2MSFTNGP05.phx.gbl...
> This is because you have the option "allow updates" set to 1 (this is obsolete in 2005 and causes
> the error you are seeing when you do not use WITH OVERRIDE. Run the following
>
> exec sp_configure 'show advanced options', 1;
> GO
> RECONFIGURE WITH OVERRIDE;
> GO
> sp_configure 'allow updates, 0;
> GO
> RECONFIGURE WITH OVERRIDE;
> GO
>
> You should now be able to run your original script with no errors.
>
>
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> http://sqlblogcasts.com/blogs/sqldbatips
>
>
> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
> news:07F98FD2-5464-4F0D-ACEC-8FC4CF604FD2@microsoft.com...
>> Yes you are right.
>>
>> The command RECONFIGURE causes this error to occur while RECONFIGURE WITH
>> OVERRIDE works fine.
>>
>> Regards Kjell Arne Johansen
>>
>> "Tibor Karaszi" wrote:
>>
>>> Are you saying that below code, in itself, generates the error you posted? I just tried on my
>>> sp2
>>> with GDR, no error message...
>>>
>>> sp_configure 'show advanced options', 1;
>>> GO
>>> RECONFIGURE;
>>> GO
>>> sp_configure 'Ole Automation Procedures', 1;
>>> GO
>>> RECONFIGURE;
>>> GO
>>>
>>> --
>>> Tibor Karaszi, SQL Server MVP
>>> http://www.karaszi.com/sqlserver/default.asp
>>> http://www.solidqualitylearning.com/
>>>
>>>
>>> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
>>> news:AC5E975F-39E6-482A-9C1D-700C613AA3C6@microsoft.com...
>>> > Hi
>>> >
>>> > This is the code causing the error message to occur when it is executed.
>>> > A month ago it worked fine.
>>> >
>>> > sp_configure 'show advanced options', 1;
>>> > GO
>>> > RECONFIGURE;
>>> > GO
>>> > sp_configure 'Ole Automation Procedures', 1;
>>> > GO
>>> > RECONFIGURE;
>>> > GO
>>> >
>>> >
>>> > Regards Kjell Arne Johansen
>>> >
>>> > "Tibor Karaszi" wrote:
>>> >
>>> >> We need to know what or who is trying to modify the system tables. Without seeing any code,
>>> >> we
>>> >> can't
>>> >> say where the problem it. My guess is that you instantiate a COM object, which in turn
>>> >> connect
>>> >> back
>>> >> to SQL Server and try to modify the system table - something you cannot do in 2005.
>>> >>
>>> >> --
>>> >> Tibor Karaszi, SQL Server MVP
>>> >> http://www.karaszi.com/sqlserver/default.asp
>>> >> http://www.solidqualitylearning.com/
>>> >>
>>> >>
>>> >> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote in message
>>> >> news:EAA6BCF7-ED40-41EF-9968-AB473829DBD8@microsoft.com...
>>> >> > Hi
>>> >> >
>>> >> > SQL Server 2005 Express.
>>> >> > 25 january 2007 I added a new procedure to my database using ole automation
>>> >> > procedures such as sp_OACreate and sp_OAMethod.
>>> >> >
>>> >> > These system procedures requires 'Ole Automation Procedures' to be enabled.
>>> >> > So I added the following to my installation script:
>>> >> > sp_configure 'show advanced options', 1;
>>> >> > GO
>>> >> > RECONFIGURE;
>>> >> > GO
>>> >> > sp_configure 'Ole Automation Procedures', 1;
>>> >> > GO
>>> >> > RECONFIGURE;
>>> >> > GO
>>> >> >
>>> >> > The script run fine and my procedue also runs fine.
>>> >> >
>>> >> > But suddenly today installaing a new database I get an error mesage:
>>> >> > "Ad hoc update to system catalogs is not supported"
>>> >> > when I run the commands above.
>>> >> > Does anyone now what has happend since january?  I installed a SP2 of SQL
>>> >> > Server Express.  Has there been any changes?
>>> >> >
>>> >> > Running "reconfigure with override" works but it is not recommended to use
>>> >> > "with override" I have read.
>>> >> >
>>> >> > Is there any other way of enabling 'Ole Automation Procedures' which is
>>> >> > allowed?
>>> >> >
>>> >> > Help is appreciated.
>>> >> >
>>> >> > Regards Kjell Arne Johansen
>>> >> >
>>> >> >
>>> >> >
>>> >>
>>> >>
>>> >>
>>>
>>>
>>>
>
>

"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:OL$AQjdgHHA.4552@TK2MSFTNGP04.phx.gbl...
>> This is because you have the option "allow updates" set to 1
>
> Good catch, Jasper. I never thought of trying with allow updates set, and
> I wouldn't have thought that having it set would cause this strange error
> message...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Jasper Smith" <jasper_smi***@hotmail.com> wrote in message
> news:OumUYWcgHHA.4900@TK2MSFTNGP05.phx.gbl...
>> This is because you have the option "allow updates" set to 1 (this is
>> obsolete in 2005 and causes the error you are seeing when you do not use
>> WITH OVERRIDE. Run the following
>>
>> exec sp_configure 'show advanced options', 1;
>> GO
>> RECONFIGURE WITH OVERRIDE;
>> GO
>> sp_configure 'allow updates, 0;
>> GO
>> RECONFIGURE WITH OVERRIDE;
>> GO
>>
>> You should now be able to run your original script with no errors.
>>
>>
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> http://sqlblogcasts.com/blogs/sqldbatips
>>
>>
>> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote
>> in message news:07F98FD2-5464-4F0D-ACEC-8FC4CF604FD2@microsoft.com...
>>> Yes you are right.
>>>
>>> The command RECONFIGURE causes this error to occur while RECONFIGURE
>>> WITH
>>> OVERRIDE works fine.
>>>
>>> Regards Kjell Arne Johansen
>>>
>>> "Tibor Karaszi" wrote:
>>>
>>>> Are you saying that below code, in itself, generates the error you
>>>> posted? I just tried on my sp2
>>>> with GDR, no error message...
>>>>
>>>> sp_configure 'show advanced options', 1;
>>>> GO
>>>> RECONFIGURE;
>>>> GO
>>>> sp_configure 'Ole Automation Procedures', 1;
>>>> GO
>>>> RECONFIGURE;
>>>> GO
>>>>
>>>> --
>>>> Tibor Karaszi, SQL Server MVP
>>>> http://www.karaszi.com/sqlserver/default.asp
>>>> http://www.solidqualitylearning.com/
>>>>
>>>>
>>>> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com>
>>>> wrote in message
>>>> news:AC5E975F-39E6-482A-9C1D-700C613AA3C6@microsoft.com...
>>>> > Hi
>>>> >
>>>> > This is the code causing the error message to occur when it is
>>>> > executed.
>>>> > A month ago it worked fine.
>>>> >
>>>> > sp_configure 'show advanced options', 1;
>>>> > GO
>>>> > RECONFIGURE;
>>>> > GO
>>>> > sp_configure 'Ole Automation Procedures', 1;
>>>> > GO
>>>> > RECONFIGURE;
>>>> > GO
>>>> >
>>>> >
>>>> > Regards Kjell Arne Johansen
>>>> >
>>>> > "Tibor Karaszi" wrote:
>>>> >
>>>> >> We need to know what or who is trying to modify the system tables.
>>>> >> Without seeing any code, we
>>>> >> can't
>>>> >> say where the problem it. My guess is that you instantiate a COM
>>>> >> object, which in turn connect
>>>> >> back
>>>> >> to SQL Server and try to modify the system table - something you
>>>> >> cannot do in 2005.
>>>> >>
>>>> >> --
>>>> >> Tibor Karaszi, SQL Server MVP
>>>> >> http://www.karaszi.com/sqlserver/default.asp
>>>> >> http://www.solidqualitylearning.com/
>>>> >>
>>>> >>
>>>> >> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com>
>>>> >> wrote in message
>>>> >> news:EAA6BCF7-ED40-41EF-9968-AB473829DBD8@microsoft.com...
>>>> >> > Hi
>>>> >> >
>>>> >> > SQL Server 2005 Express.
>>>> >> > 25 january 2007 I added a new procedure to my database using ole
>>>> >> > automation
>>>> >> > procedures such as sp_OACreate and sp_OAMethod.
>>>> >> >
>>>> >> > These system procedures requires 'Ole Automation Procedures' to be
>>>> >> > enabled.
>>>> >> > So I added the following to my installation script:
>>>> >> > sp_configure 'show advanced options', 1;
>>>> >> > GO
>>>> >> > RECONFIGURE;
>>>> >> > GO
>>>> >> > sp_configure 'Ole Automation Procedures', 1;
>>>> >> > GO
>>>> >> > RECONFIGURE;
>>>> >> > GO
>>>> >> >
>>>> >> > The script run fine and my procedue also runs fine.
>>>> >> >
>>>> >> > But suddenly today installaing a new database I get an error
>>>> >> > mesage:
>>>> >> > "Ad hoc update to system catalogs is not supported"
>>>> >> > when I run the commands above.
>>>> >> > Does anyone now what has happend since january?  I installed a SP2
>>>> >> > of SQL
>>>> >> > Server Express.  Has there been any changes?
>>>> >> >
>>>> >> > Running "reconfigure with override" works but it is not
>>>> >> > recommended to use
>>>> >> > "with override" I have read.
>>>> >> >
>>>> >> > Is there any other way of enabling 'Ole Automation Procedures'
>>>> >> > which is
>>>> >> > allowed?
>>>> >> >
>>>> >> > Help is appreciated.
>>>> >> >
>>>> >> > Regards Kjell Arne Johansen
>>>> >> >
>>>> >> >
>>>> >> >
>>>> >>
>>>> >>
>>>> >>
>>>>
>>>>
>>>>
>>
>>
>

"Jasper Smith" wrote:

> Only reason I knew is because it happened to me :-) It took me a while to
> figure out why I was getting errors doing reconfigures and to be honest I
> don't remember setting allow updates on at all.
>
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> http://sqlblogcasts.com/blogs/sqldbatips
>
>
> "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
> message news:OL$AQjdgHHA.4552@TK2MSFTNGP04.phx.gbl...
> >> This is because you have the option "allow updates" set to 1
> >
> > Good catch, Jasper. I never thought of trying with allow updates set, and
> > I wouldn't have thought that having it set would cause this strange error
> > message...
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://sqlblog.com/blogs/tibor_karaszi
> >
> >
> > "Jasper Smith" <jasper_smi***@hotmail.com> wrote in message
> > news:OumUYWcgHHA.4900@TK2MSFTNGP05.phx.gbl...
> >> This is because you have the option "allow updates" set to 1 (this is
> >> obsolete in 2005 and causes the error you are seeing when you do not use
> >> WITH OVERRIDE. Run the following
> >>
> >> exec sp_configure 'show advanced options', 1;
> >> GO
> >> RECONFIGURE WITH OVERRIDE;
> >> GO
> >> sp_configure 'allow updates, 0;
> >> GO
> >> RECONFIGURE WITH OVERRIDE;
> >> GO
> >>
> >> You should now be able to run your original script with no errors.
> >>
> >>
> >> --
> >> HTH,
> >> Jasper Smith (SQL Server MVP)
> >> http://www.sqldbatips.com
> >> http://sqlblogcasts.com/blogs/sqldbatips
> >>
> >>
> >> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com> wrote
> >> in message news:07F98FD2-5464-4F0D-ACEC-8FC4CF604FD2@microsoft.com...
> >>> Yes you are right.
> >>>
> >>> The command RECONFIGURE causes this error to occur while RECONFIGURE
> >>> WITH
> >>> OVERRIDE works fine.
> >>>
> >>> Regards Kjell Arne Johansen
> >>>
> >>> "Tibor Karaszi" wrote:
> >>>
> >>>> Are you saying that below code, in itself, generates the error you
> >>>> posted? I just tried on my sp2
> >>>> with GDR, no error message...
> >>>>
> >>>> sp_configure 'show advanced options', 1;
> >>>> GO
> >>>> RECONFIGURE;
> >>>> GO
> >>>> sp_configure 'Ole Automation Procedures', 1;
> >>>> GO
> >>>> RECONFIGURE;
> >>>> GO
> >>>>
> >>>> --
> >>>> Tibor Karaszi, SQL Server MVP
> >>>> http://www.karaszi.com/sqlserver/default.asp
> >>>> http://www.solidqualitylearning.com/
> >>>>
> >>>>
> >>>> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com>
> >>>> wrote in message
> >>>> news:AC5E975F-39E6-482A-9C1D-700C613AA3C6@microsoft.com...
> >>>> > Hi
> >>>> >
> >>>> > This is the code causing the error message to occur when it is
> >>>> > executed.
> >>>> > A month ago it worked fine.
> >>>> >
> >>>> > sp_configure 'show advanced options', 1;
> >>>> > GO
> >>>> > RECONFIGURE;
> >>>> > GO
> >>>> > sp_configure 'Ole Automation Procedures', 1;
> >>>> > GO
> >>>> > RECONFIGURE;
> >>>> > GO
> >>>> >
> >>>> >
> >>>> > Regards Kjell Arne Johansen
> >>>> >
> >>>> > "Tibor Karaszi" wrote:
> >>>> >
> >>>> >> We need to know what or who is trying to modify the system tables.
> >>>> >> Without seeing any code, we
> >>>> >> can't
> >>>> >> say where the problem it. My guess is that you instantiate a COM
> >>>> >> object, which in turn connect
> >>>> >> back
> >>>> >> to SQL Server and try to modify the system table - something you
> >>>> >> cannot do in 2005.
> >>>> >>
> >>>> >> --
> >>>> >> Tibor Karaszi, SQL Server MVP
> >>>> >> http://www.karaszi.com/sqlserver/default.asp
> >>>> >> http://www.solidqualitylearning.com/
> >>>> >>
> >>>> >>
> >>>> >> "Kjell Arne Johansen" <KjellArneJohan***@discussions.microsoft.com>
> >>>> >> wrote in message
> >>>> >> news:EAA6BCF7-ED40-41EF-9968-AB473829DBD8@microsoft.com...
> >>>> >> > Hi
> >>>> >> >
> >>>> >> > SQL Server 2005 Express.
> >>>> >> > 25 january 2007 I added a new procedure to my database using ole
> >>>> >> > automation
> >>>> >> > procedures such as sp_OACreate and sp_OAMethod.
> >>>> >> >
> >>>> >> > These system procedures requires 'Ole Automation Procedures' to be
> >>>> >> > enabled.
> >>>> >> > So I added the following to my installation script:
> >>>> >> > sp_configure 'show advanced options', 1;
> >>>> >> > GO
> >>>> >> > RECONFIGURE;
> >>>> >> > GO
> >>>> >> > sp_configure 'Ole Automation Procedures', 1;
> >>>> >> > GO
> >>>> >> > RECONFIGURE;
> >>>> >> > GO
> >>>> >> >
> >>>> >> > The script run fine and my procedue also runs fine.
> >>>> >> >
> >>>> >> > But suddenly today installaing a new database I get an error
> >>>> >> > mesage:
> >>>> >> > "Ad hoc update to system catalogs is not supported"
> >>>> >> > when I run the commands above.
> >>>> >> > Does anyone now what has happend since january?  I installed a SP2
> >>>> >> > of SQL
> >>>> >> > Server Express.  Has there been any changes?
> >>>> >> >
> >>>> >> > Running "reconfigure with override" works but it is not
> >>>> >> > recommended to use
> >>>> >> > "with override" I have read.
> >>>> >> >
> >>>> >> > Is there any other way of enabling 'Ole Automation Procedures'
> >>>> >> > which is
> >>>> >> > allowed?
> >>>> >> >
> >>>> >> > Help is appreciated.
> >>>> >> >
> >>>> >> > Regards Kjell Arne Johansen
> >>>> >> >
> >>>> >> >
> >>>> >> >
> >>>> >>
> >>>> >>
> >>>> >>
> >>>>
> >>>>
> >>>>
> >>
> >>
> >
>
>
>