Cannot see data in database table

Hi all,

I am having a problem viewing data in a database table.

The data is entered into the database with a web service and it runs without problems. However, when I open the table with the management tool, I cannot see the data I just sent to it.

Also, when I try adding data directly to the table, the id column shows that there is data in the table. That is lets say the id for the 1st item is "1", after sending 4 records to the database with the webservice, when I try to enter data in the table directly, the next available key is 5. This indicates that there is some data in the table that I cannot see.

Does anyone know how I can reslove this?

Thanks!

Hi,
perhaps the transactions has beend rolled back again, or the data was deleted by another rpocedure / database call again. To find out what wiped out the data from the database, run the profiler, tracing all action concerned to your database.

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Hugo,

Is this in a productiong system? When working in debug it is common for data to disappear because of a fluke in how VS works. Check out the FAQ at the top of this forum. Just the fact that the id is 5 doesn't mean that other records exist in the table. As Jens points out, if the record was created, but then rolled back, the id value has been burned already and won't be reused.

How are you trying to view the data?

Mike