July 23, 2007 at 1:16 am
Hi,
When I am executing a procedure with different parameters at the same time, I am getting the following error.
-------------
Server: Msg 605, Level 12, State 1, Line 1
Attempt to fetch logical page (1:50846) in database 'database_name' belongs to object 'table_name', not to object 'table_name'.
------------------
What is the cause of this issues and how can I sort out this issue?
Regards,
Ezhilan
July 23, 2007 at 1:31 am
- Can you provide the ddl or the query that produces this error ?
- do you perform a checkdb on regular basis ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 23, 2007 at 2:14 am
Hi.
We are not using..any DDL statments in this procedure. This is 14000 Line procedure which have lots of updates and inserts.
As I dont have Admin rights, I cant perform checkdb, in this database.
Kindly check it..
Regards,
E Ezhilan
July 23, 2007 at 3:01 am
hi
looks like the page may be corrypt. you will have to run the dbcc checkdb or dbcc checktable .
"Keep Trying"
July 23, 2007 at 4:57 am
Indeed a dbcc checkdb would be the first action to be taken.
If you cannot do it yourself, contact your dba-systemadmin to perform it asap.
What's your version of sqlserver are you running ?
select @@version as Version
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 25, 2007 at 2:45 am
This is the version..we are using..
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Regards,
Ezhilan
July 25, 2007 at 3:32 am
That's SP4. (=latest sp) So this should be ok.
IMO the DBCC CheckDB must be executed asap!
from Books Online:
Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.
This error occurs when Microsoft® SQL Server™ detects database corruption. The second object specified in the text not to object '%.*ls' is probably corrupt. Because this error can mask the existence of other errors, execute DBCC CHECKDB to determine the extent of the damage. If DBCC CHECKDB does not report additional errors, the first object mentioned is not corrupt.
....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply