MSSQL 2000 memory not being used.

Hi,
I have a quad box with 12 gigs of memory. I can only seem to get up to
6 gigs of memory used. I am having page fault errors and was wondering
why it is page faulting with 6 gigs of memory available. I have tried
using /3GB /PAE and just the /3GB and just the /PAE switches. This is
a Windows 2003 enterprise SP1 server.
If I look at the System Information screen I see that we have total
memory of 12 gigs.
Total Physical Memory 11,519.20 MB
But only 1 gig available for use.
Available Physical Memory 1.07 GB
If I look at the task manager I see I am only using 6 gigs? I am not
the best at math, but things are not adding up here.
Does anybody know the secret sause to getting the server to see the
other 6 gigs?
Much thanks in advance,
John Burris
jburris@.centrisinfo.comjohncburris@.gmail.com wrote:
> Hi,
> I have a quad box with 12 gigs of memory. I can only seem to get up to
> 6 gigs of memory used. I am having page fault errors and was wondering
> why it is page faulting with 6 gigs of memory available. I have tried
> using /3GB /PAE and just the /3GB and just the /PAE switches. This is
> a Windows 2003 enterprise SP1 server.
> If I look at the System Information screen I see that we have total
> memory of 12 gigs.
> Total Physical Memory 11,519.20 MB
> But only 1 gig available for use.
> Available Physical Memory 1.07 GB
> If I look at the task manager I see I am only using 6 gigs? I am not
> the best at math, but things are not adding up here.
> Does anybody know the secret sause to getting the server to see the
> other 6 gigs?
> Much thanks in advance,
> John Burris
> jburris@.centrisinfo.com
>
What SQL service pack are you on? If SP4, have you installed the AWE
hotfix?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

MSSQL 2000 memory not being used.

Hi,
I have a quad box with 12 gigs of memory. I can only seem to get up to
6 gigs of memory used. I am having page fault errors and was wondering
why it is page faulting with 6 gigs of memory available. I have tried
using /3GB /PAE and just the /3GB and just the /PAE switches. This is
a Windows 2003 enterprise SP1 server.
If I look at the System Information screen I see that we have total
memory of 12 gigs.
Total Physical Memory11,519.20 MB
But only 1 gig available for use.
Available Physical Memory1.07 GB
If I look at the task manager I see I am only using 6 gigs? I am not
the best at math, but things are not adding up here.
Does anybody know the secret sause to getting the server to see the
other 6 gigs?
Much thanks in advance,
John Burris
jburris@.centrisinfo.com
johncburris@.gmail.com wrote:
> Hi,
> I have a quad box with 12 gigs of memory. I can only seem to get up to
> 6 gigs of memory used. I am having page fault errors and was wondering
> why it is page faulting with 6 gigs of memory available. I have tried
> using /3GB /PAE and just the /3GB and just the /PAE switches. This is
> a Windows 2003 enterprise SP1 server.
> If I look at the System Information screen I see that we have total
> memory of 12 gigs.
> Total Physical Memory11,519.20 MB
> But only 1 gig available for use.
> Available Physical Memory1.07 GB
> If I look at the task manager I see I am only using 6 gigs? I am not
> the best at math, but things are not adding up here.
> Does anybody know the secret sause to getting the server to see the
> other 6 gigs?
> Much thanks in advance,
> John Burris
> jburris@.centrisinfo.com
>
What SQL service pack are you on? If SP4, have you installed the AWE
hotfix?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

MSSQL 2000 memory not being used.

Hi,
I have a quad box with 12 gigs of memory. I can only seem to get up to
6 gigs of memory used. I am having page fault errors and was wondering
why it is page faulting with 6 gigs of memory available. I have tried
using /3GB /PAE and just the /3GB and just the /PAE switches. This is
a Windows 2003 enterprise SP1 server.
If I look at the System Information screen I see that we have total
memory of 12 gigs.
Total Physical Memory 11,519.20 MB
But only 1 gig available for use.
Available Physical Memory 1.07 GB
If I look at the task manager I see I am only using 6 gigs? I am not
the best at math, but things are not adding up here.
Does anybody know the secret sause to getting the server to see the
other 6 gigs?
Much thanks in advance,
John Burris
jburris@.centrisinfo.comjohncburris@.gmail.com wrote:
> Hi,
> I have a quad box with 12 gigs of memory. I can only seem to get up to
> 6 gigs of memory used. I am having page fault errors and was wondering
> why it is page faulting with 6 gigs of memory available. I have tried
> using /3GB /PAE and just the /3GB and just the /PAE switches. This is
> a Windows 2003 enterprise SP1 server.
> If I look at the System Information screen I see that we have total
> memory of 12 gigs.
> Total Physical Memory 11,519.20 MB
> But only 1 gig available for use.
> Available Physical Memory 1.07 GB
> If I look at the task manager I see I am only using 6 gigs? I am not
> the best at math, but things are not adding up here.
> Does anybody know the secret sause to getting the server to see the
> other 6 gigs?
> Much thanks in advance,
> John Burris
> jburris@.centrisinfo.com
>
What SQL service pack are you on? If SP4, have you installed the AWE
hotfix?
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql

MSRS + Fit to Page

Hi,

I need to be able to fit a report onto one page of Landscape A4. I can set the page orientation to Landscape, but I cant find anyway of setting it to print on one page.

If not, is there a way to have a 'Fit to' option where you specify the number of pages wide and the no. of pages long?

Can anyone help?

CheersWhether a report fits onto a single page is dictated by whether the contents exceed the page width and page height minus margins. There is not 'fit to page' option but it is something we would like to have in a future release.|||

Hi

I, too, am running into this same problem. Has anything new been done to provide a 'fit to page' option? Or has anyone written code to get around this? Any help would be greatly appreciated.

Thanks

|||Fit to Page would be great. Is this on SP2 or scheduled for development some time?

MSRS + Fit to Page

Hi,

I need to be able to fit a report onto one page of Landscape A4. I can set the page orientation to Landscape, but I cant find anyway of setting it to print on one page.

If not, is there a way to have a 'Fit to' option where you specify the number of pages wide and the no. of pages long?

Can anyone help?

CheersWhether a report fits onto a single page is dictated by whether the contents exceed the page width and page height minus margins. There is not 'fit to page' option but it is something we would like to have in a future release.|||

Hi

I, too, am running into this same problem. Has anything new been done to provide a 'fit to page' option? Or has anyone written code to get around this? Any help would be greatly appreciated.

Thanks

|||Fit to Page would be great. Is this on SP2 or scheduled for development some time?sql

MSRS + Fit to Page

Hi,

I need to be able to fit a report onto one page of Landscape A4. I can set the page orientation to Landscape, but I cant find anyway of setting it to print on one page.

If not, is there a way to have a 'Fit to' option where you specify the number of pages wide and the no. of pages long?

Can anyone help?

CheersWhether a report fits onto a single page is dictated by whether the contents exceed the page width and page height minus margins. There is not 'fit to page' option but it is something we would like to have in a future release.|||

Hi

I, too, am running into this same problem. Has anything new been done to provide a 'fit to page' option? Or has anyone written code to get around this? Any help would be greatly appreciated.

Thanks

|||Fit to Page would be great. Is this on SP2 or scheduled for development some time?

Msg 624 Could not retrieve row from page by RID...

Running:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
Scott
Additional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.
|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/de...err_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:

>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>
|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
http://msdn.microsoft.com/library/de...err_1_23p0.asp[vbcol=seagreen]
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
row[vbcol=seagreen]

Msg 624 Could not retrieve row from page by RID...

Running:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
ScottAdditional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:
>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
> >Running:
> >Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> > Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation
> > Standard Edition on Windows NT 5.2 (Build 3790: )
> >
> >I have a stored procedure that is returning the following error:
> >
> >Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
> >Could not retrieve row from page by RID because the requested RID has a
> >higher number than the last RID on the page. Rid pageid is (1:5697) and
row
> >num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
> >objectid = 1371279390, indexid = 0, DBID 2.
> >Connection Broken
> >
> >Line 170 of the sp is running the following update:
> >
> >Update f set
> > LinkID = OwnerOID
> >From #working f
> >JOIN EventDetail d on d.EventDetailID = f.EventDetailID
> >Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
> >
> >If I comment out that update, the error goes away. Sounds like a corrupt
> >EventDetail index (PK is EventDetailID nonclustered). So I recreated the
> >table and all indexes. Still getting the error.
> >
> >I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
> >table summaries):
> >CHECKDB found 0 allocation errors and 0 consistency errors in database
> >'ELASAdmin'.
> >DBCC execution completed. If DBCC printed error messages, contact your
> >system administrator.
> >
> >Any idea where I should go from here?
> >
> >TIA,
> >
> >Scott
> >
> >
> >
> >

Msg 624 Could not retrieve row from page by RID...

Running:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
I have a stored procedure that is returning the following error:
Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
Could not retrieve row from page by RID because the requested RID has a
higher number than the last RID on the page. Rid pageid is (1:5697) and row
num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
objectid = 1371279390, indexid = 0, DBID 2.
Connection Broken
Line 170 of the sp is running the following update:
Update f set
LinkID = OwnerOID
From #working f
JOIN EventDetail d on d.EventDetailID = f.EventDetailID
Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
If I comment out that update, the error goes away. Sounds like a corrupt
EventDetail index (PK is EventDetailID nonclustered). So I recreated the
table and all indexes. Still getting the error.
I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
table summaries):
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ELASAdmin'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Any idea where I should go from here?
TIA,
ScottAdditional info:
This error happens on multiple servers (production and dev)
DBID 2 is the tempdb (I did shut down SS and deleted the tempdb. After
restarting...same error.)
This SP had been running fine for about a year.|||Product support might be the next place to do, unfortunately.
http://msdn.microsoft.com/library/d...serr_1_23p0.asp
The only other thing I might try first is ANSI syntax for the update:
update #working set
LinkID = (
select OwnerOID
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
where exists (
select *
from EventDetail d
where d.EventDetailID = #working.EventDetailID
and #working.OwnerTypeCode = 4
and EventDetail.TextBuffer1 like '%internalrx=False%'
)
Steve Kass
Drew University
Scott wrote:

>Running:
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>I have a stored procedure that is returning the following error:
>Server: Msg 624, Level 20, State 2, Procedure Rpt27310Bal, Line 170
>Could not retrieve row from page by RID because the requested RID has a
>higher number than the last RID on the page. Rid pageid is (1:5697) and row
>num is 0x47.Page pointer = 0x2b778000, PageId = (1:5697), flags = 0x8008,
>objectid = 1371279390, indexid = 0, DBID 2.
>Connection Broken
>Line 170 of the sp is running the following update:
>Update f set
> LinkID = OwnerOID
>From #working f
>JOIN EventDetail d on d.EventDetailID = f.EventDetailID
>Where f.OwnerTypeCode = 4 and d.TextBuffer1 like '%internaltrx=False%'
>If I comment out that update, the error goes away. Sounds like a corrupt
>EventDetail index (PK is EventDetailID nonclustered). So I recreated the
>table and all indexes. Still getting the error.
>I ran DBCC Checkdb with Repair_rebuild. It returned (along with all the
>table summaries):
>CHECKDB found 0 allocation errors and 0 consistency errors in database
>'ELASAdmin'.
>DBCC execution completed. If DBCC printed error messages, contact your
>system administrator.
>Any idea where I should go from here?
>TIA,
>Scott
>
>|||I did see and completed the steps in the MSDN article before posting.
Your ANSI update worked! Do I dare ask why? Like I said, this SP has been
in production for over a year (its for a report that's emailed daily), then
on Friday I get this error.
I did look at the contents of #working just prior to the update and it only
contained about 30 records that looked 'normal'. I'll play around with it
some more on Monday...
Thanks for your help Steve,
Scott
"Steve Kass" <skass@.drew.edu> wrote in message
news:u0rIky$aEHA.556@.tk2msftngp13.phx.gbl...
> Product support might be the next place to do, unfortunately.
>
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23p0.asp[
/url][vbcol=seagreen]
> The only other thing I might try first is ANSI syntax for the update:
> update #working set
> LinkID = (
> select OwnerOID
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
> where exists (
> select *
> from EventDetail d
> where d.EventDetailID = #working.EventDetailID
> and #working.OwnerTypeCode = 4
> and EventDetail.TextBuffer1 like '%internalrx=False%'
> )
>
> Steve Kass
> Drew University
> Scott wrote:
>
row[vbcol=seagreen]

Msg 2540

Msg 2540, Level 16, State 1
Allocation Discrepancy: Page is allocated but not linked;
check the following pages and ids: allocation pg#=614144
extent id=614392 logical pg#=614395 object id on extent=8
(object name = syslogs) indid on extent=0
I forgot to ask what the ramifications are if I migrate
to SQL 2000 with this message still occurring.Jim,
Always fix such problems if you can.
If all of these pages are for syslogs (ie, the transaction log) then life
might not be too bad if you migrate. But I cannot say for sure.
What I would do.
1 - Backup the database
2 - Restore the database backup to a different database, e.g.
mydatabaseRestore
3 - Run the fixes on the second database and observe the results.
Russell Fields
"Jim" <anonymous@.discussions.microsoft.com> wrote in message
news:06e601c3b399$e5d9cbd0$a101280a@.phx.gbl...
> Msg 2540, Level 16, State 1
> Allocation Discrepancy: Page is allocated but not linked;
> check the following pages and ids: allocation pg#=614144
> extent id=614392 logical pg#=614395 object id on extent=8
> (object name = syslogs) indid on extent=0
> I forgot to ask what the ramifications are if I migrate
> to SQL 2000 with this message still occurring.