Post reply

What might have truncated my table

  • March 31, 2008 at 8:50 am

    #124622

    say if I am doing an insert (50 million records) into a table.... when i check it while the query is running I see some records inserted.... however, at the end i have no data... table gets truncated. Is it so because I was out of space (I checked the drives and seems like data drive is running out of space).

    Thanks for ur help.

  • March 31, 2008 at 9:08 am

    #795990

    I think I got it.... I was seeing the select with nolock and that was still not committed. Once the databse was out of space the insert into rolledback and hence I did not see any data. Thanks.

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

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