InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:57:56 GMT20http://www.sqlservercentral.com/Forums/Topic651460-9-1.aspxJust found this post duplicate [url=http://www.sqlservercentral.com/Forums/Topic651462-145-1.aspx]here[/url] with more answers so please post there.polaiah,Please do not post duplicates as I, and possibly others, just wasted time looking at both.Thanks,Fri, 06 Feb 2009 07:24:34 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic651460-9-1.aspxThis is causing the error:[code]EXEC SP_TD_GEN_NEXTID 'GN', 'TD_SURVEY_RESULTS', 'nResultID', @pin_nResultID OUT[/code]How is this code working? When is your id value being incremented? You need to code something that shows that the id row for this table is locked until your transaction is complete.Fri, 06 Feb 2009 07:15:10 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic651460-9-1.aspxHai, ALlmy store procedure is:CREATE PROC SP_TD_SURVEY_RESULTS ( @pin_sParam varchar(10) , @pin_nResultID int , @pin_nReferenceID int , @pin_nSurveyID int , @pin_sConductedPlace varchar(20) , @pin_dtConductedPlace datetime , @pin_nActionOperatorID int , @pin_nMandalID int , @pin_nAssemblyID int )ASBEGIN--SV - Save New AgendaIF @pin_sParam = 'SV'BEGIN IF @pin_nActionOperatorID NOT IN(33,36) BEGIN EXEC SP_TD_GEN_NEXTID 'GN', 'TD_SURVEY_RESULTS', 'nResultID', @pin_nResultID OUT INSERT INTO TD_SURVEY_RESULTS (nResultID, nReferenceID,nSurveyID, sConductedPlace, dtConductedPlace , nSortOrder, bActive, nCreatedOperatorID, dtCreated,nMandalID,nAssemblyID) VALUES (@pin_nResultID , @pin_nReferenceID, @pin_nSurveyID, @pin_sConductedPlace, @pin_dtConductedPlace, @pin_nResultID ,'Y', @pin_nActionOperatorID, getdate(),@pin_nMandalID,@pin_nAssemblyID) SELECT @pin_nResultID 'nResultID', 'Success' 'sStatus' END ELSE SELECT -999 'nResultID', 'You dont have write Permissions' 'sStatus'ENDENDAbove storeprocedure i am using but in these application 50 users are used at a time.The following the error is comming how to slove that one.......Error Message:Violation of PRIMARY KEY constraint 'PK_TD_SURVEY_RESULTS'. Cannot insert duplicate key in object 'TD_SURVEY_RESULTS'. The statement has been terminated.TraceLog: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at TDPORTAL.DataAccess.DAManager.ExecuteDataset(SqlCommand cmdObject) in D:\My Projects\TDPPORTAL2005\05-Development\SourceCode\TDDataAccess\DAManager.cs:line 40 regard'spolaiah MFri, 06 Feb 2009 02:25:36 GMTpolo.csit