Is anybody know that do we have anything like Oracle's inbuilt primary key ROWID which is also accessible to database developer.
I searched for it but could not get the satisfactory answer.
There isn't one that you can access from T-SQL. You should set up a PK yourself. If you run into a situation where there isn't one on a table, you may still be able to access individual items on SQL Server 2005 and 2008 (just search the forums for removing duplicate rows)
Andras Belokosztolszki, MCPD, PhD