Getting 644 Error in log

I am getting a pair of errors in the SQL Server log:
**
Could not find the index entry for
RID '367007017019022035037037038030303130313
030303037353836
353030323431324d415220202020202020' in index page
(1:126931), index ID 2, database 'ee8idbbd'..
**
AND
**
Error: 644, Severity: 21, State: 5
**
I looked in KB article 834290 and tried Method 2 on the
affected table. There were no columns that exhibited the
given symptoms, so either I did it wrong or this does not
apply.
Can someone help me diagnose this problem before it
happens again?1. Is that the build you are on at the moment (build 904 sqlservr.exe)? If
so, you might want to call into PSS to get that hotfix.
2. Do you get this error, as the KB article claims when you run an update
on READ UNCOMMITTED?
3. You might want to run a checkdb on the database and make sure that there
are no allocation or consistency errors.
Cheers.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Getting 644 Error in log

I am getting a pair of errors in the SQL Server log:
**
Could not find the index entry for
RID '3670070170190220350370370380303031303130303030373 53836
353030323431324d415220202020202020' in index page
(1:126931), index ID 2, database 'ee8idbbd'..
**
AND
**
Error: 644, Severity: 21, State: 5
**
I looked in KB article 834290 and tried Method 2 on the
affected table. There were no columns that exhibited the
given symptoms, so either I did it wrong or this does not
apply.
Can someone help me diagnose this problem before it
happens again?
1. Is that the build you are on at the moment (build 904 sqlservr.exe)? If
so, you might want to call into PSS to get that hotfix.
2. Do you get this error, as the KB article claims when you run an update
on READ UNCOMMITTED?
3. You might want to run a checkdb on the database and make sure that there
are no allocation or consistency errors.
Cheers.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Getting 644 Error in log

I am getting a pair of errors in the SQL Server log:
**
Could not find the index entry for
RID '367007017019022035037037038030303130313030303037353836
353030323431324d415220202020202020' in index page
(1:126931), index ID 2, database 'ee8idbbd'..
**
AND
**
Error: 644, Severity: 21, State: 5
**
I looked in KB article 834290 and tried Method 2 on the
affected table. There were no columns that exhibited the
given symptoms, so either I did it wrong or this does not
apply.
Can someone help me diagnose this problem before it
happens again?1. Is that the build you are on at the moment (build 904 sqlservr.exe)? If
so, you might want to call into PSS to get that hotfix.
2. Do you get this error, as the KB article claims when you run an update
on READ UNCOMMITTED?
3. You might want to run a checkdb on the database and make sure that there
are no allocation or consistency errors.
Cheers.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

get path of the database file using a query

Hi guys,
all i want to do is , get the path of the location of my database and log
file using a query of a command i could write down in the query anylyser.
Thanks
Sameer MuzammilTry using:
sp_helpfile
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"sameer" <sameer@.discussions.microsoft.com> schrieb im Newsbeitrag
news:25DDB26C-501D-4DCA-979F-3587514744D0@.microsoft.com...
> Hi guys,
> all i want to do is , get the path of the location of my database and log
> file using a query of a command i could write down in the query anylyser.
> Thanks
> Sameer Muzammil|||Hi,
You could also use
sp_helpdb <dbname>
Thanks
Hari
SQL Server MVP
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:25DDB26C-501D-4DCA-979F-3587514744D0@.microsoft.com...
> Hi guys,
> all i want to do is , get the path of the location of my database and log
> file using a query of a command i could write down in the query anylyser.
> Thanks
> Sameer Muzammil|||Hi Sameer,
You can extract info from sysdatabses system table. As Jens replied you
sp_helpfile this system stored procdure also make use of this system table.
select name,filename from sysdatabases
go
Thanks
Syed Zulfiqar
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:25DDB26C-501D-4DCA-979F-3587514744D0@.microsoft.com...
> Hi guys,
> all i want to do is , get the path of the location of my database and log
> file using a query of a command i could write down in the query anylyser.
> Thanks
> Sameer Muzammil