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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Having id problem in our application

Author  Topic 

tanu
Yak Posting Veteran

57 Posts

Posted - 2008-08-21 : 16:39:59
One faculty updated her contact info and when she saved, other faculty's info showed up for her. This other person stated that he was updating his info as well few seconds earlier.

What do you think is happening? Our software vendor suggested to apply this hotfix http://support.microsoft.com/kb/940569.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-21 : 16:44:22
Looks like Locking issues .
Go to Top of Page

tanu
Yak Posting Veteran

57 Posts

Posted - 2008-08-21 : 16:59:35
Information is saving in address table and application takes that addressid and facultyid and inserting them in link table.
Every time they update it creates new record in address table and make previous one inactive.

If one person creates a record it creates an id and that id is getting inserted into other person's record in link table.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-08-21 : 18:40:59
More than likely, it’s just badly done code.



CODO ERGO SUM
Go to Top of Page
   

- Advertisement -