Jul 6, 2005 #1 KCcasey Programmer Sep 30, 2003 69 NZ Help Gurus! What options do I have at my disposal to identify the physical row location of a row in a table? Thanks in advance, Casey.
Help Gurus! What options do I have at my disposal to identify the physical row location of a row in a table? Thanks in advance, Casey.
Jul 7, 2005 1 #2 hmckillop Programmer Oct 30, 2001 1,540 GB you can write some code to lock your row using paglock. Then you can use the undocumented procedure called Code: DBCC PAGE to get the physical info. Have a look at it in more detail at: http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp not sure if this will give the info you are looking for. "I'm living so far beyond my income that we may almost be said to be living apart Upvote 0 Downvote
you can write some code to lock your row using paglock. Then you can use the undocumented procedure called Code: DBCC PAGE to get the physical info. Have a look at it in more detail at: http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp not sure if this will give the info you are looking for. "I'm living so far beyond my income that we may almost be said to be living apart