Msg 8964 After applying sql server service pack 4

Even though I have installed the latest sql server service pack (4). When I
run the dbcc checkdb statement with the arithabort set to on for one of my
production databases, I still get a few line with the error:
Server: Msg 8964, Level 16, State 1, Line 4
Table error: Object ID 2. The text, ntext, or image node at page (1:380425),
slot 2, text ID 2789285298176 is not referenced.
Even when I run: SELECT @.@.VERSION system stored procedure it returns
Microsoft SQL Server 2000 -8.00.2039(Intel x86)
As the version that I am using. I have also just today re-applied the
service pack following step by step the instruction in the sqlreadme for
service pack 4. I have read a solution that suggested re-installing sql
server but that is just not an option right now, because of the fact that it
is a production database that is in constant use. I'm also starting to think
that these arent necessarily errors that are critical. Could someone
help\advise?
Many thanks
Hi
There is nothing wrong with your SP level, but you have corruption in your
DB that applying a SP can not help to fix. SP's do not affect user DB's,
only system DB's.
run DBCC with the REPAIR_ALLOW_DATA_LOSS option. For more information on
the command, look in Books Online.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Fazz" <farayi@.lovetm.co.uk> wrote in message
news:u%23QrmC9$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Even though I have installed the latest sql server service pack (4). When
> I run the dbcc checkdb statement with the arithabort set to on for one of
> my production databases, I still get a few line with the error:
> Server: Msg 8964, Level 16, State 1, Line 4
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:380425), slot 2, text ID 2789285298176 is not referenced.
> Even when I run: SELECT @.@.VERSION system stored procedure it returns
> Microsoft SQL Server 2000 -8.00.2039(Intel x86)
> As the version that I am using. I have also just today re-applied the
> service pack following step by step the instruction in the sqlreadme for
> service pack 4. I have read a solution that suggested re-installing sql
> server but that is just not an option right now, because of the fact that
> it is a production database that is in constant use. I'm also starting to
> think that these arent necessarily errors that are critical. Could someone
> help\advise?
> Many thanks
>

Msg 8964 After applying sql server service pack 4

Even though I have installed the latest sql server service pack (4). When I
run the dbcc checkdb statement with the arithabort set to on for one of my
production databases, I still get a few line with the error:
Server: Msg 8964, Level 16, State 1, Line 4
Table error: Object ID 2. The text, ntext, or image node at page (1:380425),
slot 2, text ID 2789285298176 is not referenced.
Even when I run: SELECT @.@.VERSION system stored procedure it returns
Microsoft SQL Server 2000 -8.00.2039(Intel x86)
As the version that I am using. I have also just today re-applied the
service pack following step by step the instruction in the sqlreadme for
service pack 4. I have read a solution that suggested re-installing sql
server but that is just not an option right now, because of the fact that it
is a production database that is in constant use. I'm also starting to think
that these arent necessarily errors that are critical. Could someone
help\advise?
Many thanksHi
There is nothing wrong with your SP level, but you have corruption in your
DB that applying a SP can not help to fix. SP's do not affect user DB's,
only system DB's.
run DBCC with the REPAIR_ALLOW_DATA_LOSS option. For more information on
the command, look in Books Online.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Fazz" <farayi@.lovetm.co.uk> wrote in message
news:u%23QrmC9$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Even though I have installed the latest sql server service pack (4). When
> I run the dbcc checkdb statement with the arithabort set to on for one of
> my production databases, I still get a few line with the error:
> Server: Msg 8964, Level 16, State 1, Line 4
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:380425), slot 2, text ID 2789285298176 is not referenced.
> Even when I run: SELECT @.@.VERSION system stored procedure it returns
> Microsoft SQL Server 2000 -8.00.2039(Intel x86)
> As the version that I am using. I have also just today re-applied the
> service pack following step by step the instruction in the sqlreadme for
> service pack 4. I have read a solution that suggested re-installing sql
> server but that is just not an option right now, because of the fact that
> it is a production database that is in constant use. I'm also starting to
> think that these arent necessarily errors that are critical. Could someone
> help\advise?
> Many thanks
>

Msg 8964 After applying sql server service pack 4

Even though I have installed the latest sql server service pack (4). When I
run the dbcc checkdb statement with the arithabort set to on for one of my
production databases, I still get a few line with the error:
Server: Msg 8964, Level 16, State 1, Line 4
Table error: Object ID 2. The text, ntext, or image node at page (1:380425),
slot 2, text ID 2789285298176 is not referenced.
Even when I run: SELECT @.@.VERSION system stored procedure it returns
Microsoft SQL Server 2000 -8.00.2039(Intel x86)
As the version that I am using. I have also just today re-applied the
service pack following step by step the instruction in the sqlreadme for
service pack 4. I have read a solution that suggested re-installing sql
server but that is just not an option right now, because of the fact that it
is a production database that is in constant use. I'm also starting to think
that these arent necessarily errors that are critical. Could someone
help\advise?
Many thanksHi
There is nothing wrong with your SP level, but you have corruption in your
DB that applying a SP can not help to fix. SP's do not affect user DB's,
only system DB's.
run DBCC with the REPAIR_ALLOW_DATA_LOSS option. For more information on
the command, look in Books Online.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Fazz" <farayi@.lovetm.co.uk> wrote in message
news:u%23QrmC9$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Even though I have installed the latest sql server service pack (4). When
> I run the dbcc checkdb statement with the arithabort set to on for one of
> my production databases, I still get a few line with the error:
> Server: Msg 8964, Level 16, State 1, Line 4
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:380425), slot 2, text ID 2789285298176 is not referenced.
> Even when I run: SELECT @.@.VERSION system stored procedure it returns
> Microsoft SQL Server 2000 -8.00.2039(Intel x86)
> As the version that I am using. I have also just today re-applied the
> service pack following step by step the instruction in the sqlreadme for
> service pack 4. I have read a solution that suggested re-installing sql
> server but that is just not an option right now, because of the fact that
> it is a production database that is in constant use. I'm also starting to
> think that these arent necessarily errors that are critical. Could someone
> help\advise?
> Many thanks
>

MSDN Subscription Level for latest Yukon CTP

I'm working on some research that requires me to have access to the
latest CTP of Yukon, and I know it's available via MSDN subscription.
Can anyone tell me the minimum subscription level required to have
download access to the CTP?
Thanks
AllenSearch for SQL ServerT 2005 within
http://msdn.microsoft.com/subscript...ackinglist.aspx
It looks like it is included with MSDN Professional.
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:825fv05697ud46c5iqrm63r9gl8fhep73e@.
4ax.com...
> I'm working on some research that requires me to have access to the
> latest CTP of Yukon, and I know it's available via MSDN subscription.
> Can anyone tell me the minimum subscription level required to have
> download access to the CTP?
> Thanks
> Allen|||Thanks, Kieth, but in the shipment lists in all levels it only shows
Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
is available for download on the web site at least at the Universal
level. I'm looking to find out the minimum level at which it's
available.
Allen
On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
<sqlguy.back2u@.comcast.net> wrote:

>Search for SQL ServerT 2005 within
>http://msdn.microsoft.com/subscript...ackinglist.aspx
>It looks like it is included with MSDN Professional.|||My point is:
If it ships with version x of the MSDN Subscription then it should be
available via the download center.
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:lm6fv0h1d1r4mdjmjeiedsro5g2nbe9jnp@.
4ax.com...
> Thanks, Kieth, but in the shipment lists in all levels it only shows
> Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
> is available for download on the web site at least at the Universal
> level. I'm looking to find out the minimum level at which it's
> available.
> Allen
> On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
> <sqlguy.back2u@.comcast.net> wrote:
>
>|||Keith Kratochvil wrote:

>My point is:
>If it ships with version x of the MSDN Subscription then it should be
>available via the download center.
>
>
Yes, but the converse is not true. The download center provides much more
than what is shipped. The CTP builds of SQL Server, not the Beta releases,
are what the poster asked about, and they are not included in any MSDN
shipments, so the shipment lists won't help answer the question.
I believe the two CTP builds released so far are available to all
MSDN subscribers, regardless of subscription level. At least that's
what it says at
http://www.microsoft.com/presspass/...erLowCostPR.asp
I haven't heard anyone complain that they are an MSDN
subscriber but couldn't get the CTP, either. For the record,
the December CTP of the Express version (the SQL engine
with some limitations and no tools) is available to anyone,
MSDN subscriber or not, here:
http://lab.msdn.microsoft.com/express/sql/
Steve Kass
Drew University|||Thanks
Keith|||Thanks, Steve. That linked helped a lot.
Allen
On Wed, 26 Jan 2005 09:35:31 -0500, Steve Kass <skass@.drew.edu> wrote:

>
>Keith Kratochvil wrote:
>
>Yes, but the converse is not true. The download center provides much more
>than what is shipped. The CTP builds of SQL Server, not the Beta releases,
>are what the poster asked about, and they are not included in any MSDN
>shipments, so the shipment lists won't help answer the question.
>I believe the two CTP builds released so far are available to all
>MSDN subscribers, regardless of subscription level. At least that's
>what it says at
>http://www.microsoft.com/presspass/...om/express/sql/
>Steve Kass
>Drew University

MSDN Subscription Level for latest Yukon CTP

I'm working on some research that requires me to have access to the
latest CTP of Yukon, and I know it's available via MSDN subscription.
Can anyone tell me the minimum subscription level required to have
download access to the CTP?
Thanks
Allen
Search for SQL ServerT 2005 within
http://msdn.microsoft.com/subscripti...ckinglist.aspx
It looks like it is included with MSDN Professional.
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:825fv05697ud46c5iqrm63r9gl8fhep73e@.4ax.com...
> I'm working on some research that requires me to have access to the
> latest CTP of Yukon, and I know it's available via MSDN subscription.
> Can anyone tell me the minimum subscription level required to have
> download access to the CTP?
> Thanks
> Allen
|||Thanks, Kieth, but in the shipment lists in all levels it only shows
Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
is available for download on the web site at least at the Universal
level. I'm looking to find out the minimum level at which it's
available.
Allen
On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
<sqlguy.back2u@.comcast.net> wrote:

>Search for SQL ServerT 2005 within
>http://msdn.microsoft.com/subscripti...ckinglist.aspx
>It looks like it is included with MSDN Professional.
|||My point is:
If it ships with version x of the MSDN Subscription then it should be
available via the download center.
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:lm6fv0h1d1r4mdjmjeiedsro5g2nbe9jnp@.4ax.com...
> Thanks, Kieth, but in the shipment lists in all levels it only shows
> Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
> is available for download on the web site at least at the Universal
> level. I'm looking to find out the minimum level at which it's
> available.
> Allen
> On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
> <sqlguy.back2u@.comcast.net> wrote:
>
|||Keith Kratochvil wrote:

>My point is:
>If it ships with version x of the MSDN Subscription then it should be
>available via the download center.
>
>
Yes, but the converse is not true. The download center provides much more
than what is shipped. The CTP builds of SQL Server, not the Beta releases,
are what the poster asked about, and they are not included in any MSDN
shipments, so the shipment lists won't help answer the question.
I believe the two CTP builds released so far are available to all
MSDN subscribers, regardless of subscription level. At least that's
what it says at
http://www.microsoft.com/presspass/p...rLowCostPR.asp
I haven't heard anyone complain that they are an MSDN
subscriber but couldn't get the CTP, either. For the record,
the December CTP of the Express version (the SQL engine
with some limitations and no tools) is available to anyone,
MSDN subscriber or not, here:
http://lab.msdn.microsoft.com/express/sql/
Steve Kass
Drew University
|||Thanks
Keith
|||Thanks, Steve. That linked helped a lot.
Allen
On Wed, 26 Jan 2005 09:35:31 -0500, Steve Kass <skass@.drew.edu> wrote:

>
>Keith Kratochvil wrote:
>Yes, but the converse is not true. The download center provides much more
>than what is shipped. The CTP builds of SQL Server, not the Beta releases,
>are what the poster asked about, and they are not included in any MSDN
>shipments, so the shipment lists won't help answer the question.
>I believe the two CTP builds released so far are available to all
>MSDN subscribers, regardless of subscription level. At least that's
>what it says at
>http://www.microsoft.com/presspass/p...rLowCostPR.asp
>I haven't heard anyone complain that they are an MSDN
>subscriber but couldn't get the CTP, either. For the record,
>the December CTP of the Express version (the SQL engine
>with some limitations and no tools) is available to anyone,
>MSDN subscriber or not, here:
>http://lab.msdn.microsoft.com/express/sql/
>Steve Kass
>Drew University

MSDN Subscription Level for latest Yukon CTP

I'm working on some research that requires me to have access to the
latest CTP of Yukon, and I know it's available via MSDN subscription.
Can anyone tell me the minimum subscription level required to have
download access to the CTP?
Thanks
AllenSearch for SQL ServerT 2005 within
http://msdn.microsoft.com/subscriptions/index/packinglist.aspx
It looks like it is included with MSDN Professional.
--
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:825fv05697ud46c5iqrm63r9gl8fhep73e@.4ax.com...
> I'm working on some research that requires me to have access to the
> latest CTP of Yukon, and I know it's available via MSDN subscription.
> Can anyone tell me the minimum subscription level required to have
> download access to the CTP?
> Thanks
> Allen|||Thanks, Kieth, but in the shipment lists in all levels it only shows
Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
is available for download on the web site at least at the Universal
level. I'm looking to find out the minimum level at which it's
available.
Allen
On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
<sqlguy.back2u@.comcast.net> wrote:
>Search for SQL ServerT 2005 within
>http://msdn.microsoft.com/subscriptions/index/packinglist.aspx
>It looks like it is included with MSDN Professional.|||My point is:
If it ships with version x of the MSDN Subscription then it should be
available via the download center.
--
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:lm6fv0h1d1r4mdjmjeiedsro5g2nbe9jnp@.4ax.com...
> Thanks, Kieth, but in the shipment lists in all levels it only shows
> Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
> is available for download on the web site at least at the Universal
> level. I'm looking to find out the minimum level at which it's
> available.
> Allen
> On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
> <sqlguy.back2u@.comcast.net> wrote:
> >Search for SQL ServerT 2005 within
> >http://msdn.microsoft.com/subscriptions/index/packinglist.aspx
> >It looks like it is included with MSDN Professional.
>|||Keith Kratochvil wrote:
>My point is:
>If it ships with version x of the MSDN Subscription then it should be
>available via the download center.
>
>
Yes, but the converse is not true. The download center provides much more
than what is shipped. The CTP builds of SQL Server, not the Beta releases,
are what the poster asked about, and they are not included in any MSDN
shipments, so the shipment lists won't help answer the question.
I believe the two CTP builds released so far are available to all
MSDN subscribers, regardless of subscription level. At least that's
what it says at
http://www.microsoft.com/presspass/press/2004/dec04/12-03ServerLowCostPR.asp
I haven't heard anyone complain that they are an MSDN
subscriber but couldn't get the CTP, either. For the record,
the December CTP of the Express version (the SQL engine
with some limitations and no tools) is available to anyone,
MSDN subscriber or not, here:
http://lab.msdn.microsoft.com/express/sql/
Steve Kass
Drew University|||Thanks
--
Keith|||Thanks, Steve. That linked helped a lot.
Allen
On Wed, 26 Jan 2005 09:35:31 -0500, Steve Kass <skass@.drew.edu> wrote:
>
>Keith Kratochvil wrote:
>>My point is:
>>If it ships with version x of the MSDN Subscription then it should be
>>available via the download center.
>>
>Yes, but the converse is not true. The download center provides much more
>than what is shipped. The CTP builds of SQL Server, not the Beta releases,
>are what the poster asked about, and they are not included in any MSDN
>shipments, so the shipment lists won't help answer the question.
>I believe the two CTP builds released so far are available to all
>MSDN subscribers, regardless of subscription level. At least that's
>what it says at
>http://www.microsoft.com/presspass/press/2004/dec04/12-03ServerLowCostPR.asp
>I haven't heard anyone complain that they are an MSDN
>subscriber but couldn't get the CTP, either. For the record,
>the December CTP of the Express version (the SQL engine
>with some limitations and no tools) is available to anyone,
>MSDN subscriber or not, here:
>http://lab.msdn.microsoft.com/express/sql/
>Steve Kass
>Drew University