Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karthicklnt
Starting Member
2 Posts |
 Posted - 2011-09-05 : 01:13:14
|
| I have table Delete_User which has one column Slno which is primary key with Identity(1,1). After the rows of data inserted in the table it shows me the below data while selecting the table6256376386396436928178309059249349351042which represents the data missing. Note: Am not using the delete statement to this table.Please help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-05 : 02:14:43
|
| there might be some contraints present in table which might have prevent few data from being successfully inserted as it will cause transaction to rollback in case of any conflicts------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
karthicklnt
Starting Member
2 Posts |
Posted - 2011-09-05 : 02:48:02
|
| Hey Visakh, Thanks yaar..now i got it... transaction is one which leads to this |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-05 : 02:49:42
|
you're welcome  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-09-05 : 07:32:22
|
| Also if you are worried about gaps dont use identity columnMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Identity problem