Record not displaying

• gupta1282

  Default port

  Points: 1465

  More actions

  October 21, 2009 at 7:26 am

  #385618

  Respected All

  I have a problem regarding fetching records

  when i use

  select * from table shows 0 records

  but

  select * from table with (nolock) shows records

  I have restarted sql server and have put database in singhle user mode , no other transaction is there , no locking on this table , after that still having this problem .

  One thing, record is not new , it is 3 month old record

  can somebody suggest me "how to solve this problem " ?

  Thanks

  Ghanshyam

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 21, 2009 at 9:08 am

  #1068933

  That record belongs to an uncommited transaction.

  What I find strange is that after stopping /starting the service (which I would never have recommended!!!), all uncommited transactions should have gone rolled back.

  -- Gianluca Sartori

• vijayanj

  SSC Veteran

  Points: 262

  More actions

  October 22, 2009 at 1:19 am

  #1069254

  Hi,

  Check your transactionlevel using DBCC USEROPTIONS