Post reply

Record not displaying

  • 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

  • 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

  • October 22, 2009 at 1:19 am

    #1069254

    Hi,

    Check your transactionlevel using DBCC USEROPTIONS

Viewing 3 posts - 1 through 2 (of 2 total)

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