You are here: Re: Unaccountable jump in Identity column value « MsSQL Server « IT news, forums, messages
Re: Unaccountable jump in Identity column value

Posted by Erland Sommarskog on 08/17/07 21:52

(teddysnips@hotmail.com) writes:
> I take your point. However, all transactions on this system are user-
> initiated, especially the generation of this particular type of
> record. Further, there is currently only one user of the system
> (though it is, believe it or not, mission critical, and this is a
> major aerospace company!) and he would not hit the "Add New Record"
> button 3,000 times. If it failed the first time, he'd call me!
>
> Just to keep this up-do-date, I have heard from the sysadmin that
> there are other databases (which my company does not support) on the
> same database server where the data has been quadruplicated!

Obviously someone has inserted (attempt to insert) a lot of data, presumably
not through a GUI but through some SQL manipulation.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация