Row Level Data

Question

Post reply

Row Level Data

sudhakara

SSCrazy Eights

Points: 9425
More actions
May 6, 2008 at 6:26 am

#182021

How can i see the data of particular row id ex:
KEY: 8:72057605279514624(6d020e2b1505) this is key id i want see the data of this key .
Thanks in Advance .

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Are you talking about:

select *

from dbo.Table

where KEY = '8:72057605279514624(6d020e2b1505)'

Or do you mean something else?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 2

i want retrieve the data from data base files not from table . each row has one unique row key ,if blacking happen its showing that row id for that row id , want retrieve the data .

GSquared SSC Guru Points: 260824 More actions · Answer 3

I can't help you on that one. I have no clue how to go about bypassing the database engine and reading the data directly from the file.

(I have to admit, I also can't think of a good reason to do that. But since you apparently have, I'll assume you really do need to.)

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 4

sudhakara (5/6/2008)
i want retrieve the data from data base files not from table . each row has one unique row key ,if blacking happen its showing that row id for that row id , want retrieve the data .

I have to ask - why are you trying to bypass the database engine? messing with the database files directly is a fast highway to "Destroyed Database Land", and with noone willing to help you in any way other than how to restore the database files.

If you don't like the database environment for whatever reason - then I'd suggest you export the data to external files, and do whatever you like there. As a pure storage mechanism, database files can be rather wasteful, since they store a LOT of metadata, indexing info, etc... that can only be used by the database engine. So - if you don't plan on USING the database engine - then don't store anything in there.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 5

I think that the DBCC PAGE command might work here, not knowing if you have the required information, but as Matt mentioned, why do you need to do it this way? Where did you get the row ID from?

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 6

Am getting the row id from sp_who when blocking happen . reason is same row id blocking somany session id .