I want to know what lock is been put on the table if run below statement
Select top 5000 from table1
I tried to examine by sp_lock spid;
I gives type as TAB.
And if run the Select top 1 from table1 it also say the type as TAB.
In the MSDN TAB = Lock on an entire table, including all data and indexes.
I want to know why there is Table lock is been put even if query returns 1 record?
This is standalone test database, and my session is active. There is no other transaction happening in the db.