Re: script fails during sp3
From: cem (cayaz@att.net)
Date: 02/03/03
- Next message: SQL Server Development Team [MSFT]: "Re: AUTHENTICATION TO APPLY SP3"
- Previous message: Mike: "Permissions Question"
- In reply to: Roger Wolter[MSFT]: "Re: script fails during sp3"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "cem" <cayaz@att.net> Date: Mon, 3 Feb 2003 09:56:29 -0800
i did not run instmsdb.sql, simply because i am not sure
what script ran and which didnt. there are many scripts,
and i'm not sure of the order in which they need to run
for all of them to succeed for sql2k sp3. do you have an
idea of the script file execution order ?
>-----Original Message-----
>So if you run instmsdb.sql first, does 80sp3-tools.sql
run correctly? It
>sounds like your msdb database didn't get built correctly
at some point.
>Normally, instmsdb.sql should have been run as part of
the database
>installation.
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>
>"cem" <cayaz@att.net> wrote in message
>news:042301c2cb04$bf1aaf60$8ef82ecf@TK2MSFTNGXA04...
>> i noticed that the column/table in question is in
another
>> script file (instmsdb.sql). it seems that the
>> instmsdb.sql never got executed to update the
sysoperators
>> table. why did this happen ??
>>
>> >-----Original Message-----
>> >I suppose it's probably time to contact PSS on this. I
>> assume it means that
>> >there's a column missing from one of the system tables
in
>> your current
>> >database. You can comment out the sp that doesn't work
>> to get the rest of
>> >SP3 to install while you're figuring out what happened
to
>> your notification
>> >tables.
>> >
>> >--
>> >This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>> >
>> >
>> >"cem" <cayaz@att.net> wrote in message
>> >news:004701c2ca7d$8f011210$8df82ecf@TK2MSFTNGXA02...
>> >> i had updated my question with more details in
another
>> >> newsgroup section;
>> >> i get the following error applying sql2k sp3.
>> >>
>> >> error running script: 80sp3-tools.sql (1)
>> >>
>> >> the sql2k is on win2k server with latest service
packs.
>> >> mdac 2.7 has already been installed. the box is a
>> compaq
>> >> proliant dl380 g2 server.
>> >>
>> >> the message in the out file references an error
during
>> the
>> >> creation of the stored proc sp_enlist_tsx, line 175
>> >> Invalid column name 'netsend address'
>> >>
>> >> i get the same error message after i execute the
script
>> >> manually at QA.
>> >>
>> >>
>> >> >-----Original Message-----
>> >> >There should be a file named 80sp3-tools.out that
might
>> >> indicate what the
>> >> >error was.
>> >> >
>> >> >--
>> >> >This posting is provided "AS IS" with no warranties,
>> and
>> >> confers no rights.
>> >> >
>> >> >
>> >> >"cem" <cayaz@att.net> wrote in message
>> >> >news:051e01c2ca65$40b6baa0$cef82ecf@TK2MSFTNGXA08...
>> >> >> scripts that are executing during sql2k sp3
install
>> fail
>> >> >> to complete and returns with following message.
>> >> >>
>> >> >> error running script: 80sp3-tools.sql (1)
>> >> >>
>> >> >> any clues ?
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: SQL Server Development Team [MSFT]: "Re: AUTHENTICATION TO APPLY SP3"
- Previous message: Mike: "Permissions Question"
- In reply to: Roger Wolter[MSFT]: "Re: script fails during sp3"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
