I just redid my original insert statement and now it works:

INSERT INTO Designs

                      (DESIGN_NUM, END_RINGS, COLOR_TABS, STUDIO_INSTR, FILMS)

VALUES     ('CC 25641',1,0,1,0)

So what would cause this?  Was this being block by another...

How do you check to see if it is being blocked by another spid?

How would/why another spid block a new row insert?

The design_detail table has 107,628 rows:

Here is the table script:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Designs_Detail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Designs_Detail]

GO

CREATE TABLE [dbo].[Designs_Detail] (

 [DESIGN_NUM] [nvarchar]...

CC 25631 OR CC 25639 OR CC 25641 don't work. But, CC 25621 does work..this is weird...

There are only 14,355 rows.

I do not see any triggers; this is a very simple database.  There is a relationship on the design and design_detail tables.

Here is the table script:

if...

sql2005 9.00.3054.00

What should I use for options on the export wizard, would I select the File System?  And once exported, how do I open it? What is VSS?  Would I use...

Yes, I agree the table should not be opened to display all rows in the production environment.  One of our developers was working on an issue and opened this table...

I checked the Windows Event Viewer and found errors yesterday and today for the time frame (12 noon) the services ended.  The errors are regarding scheduled Windows Update Agent:  Windows...

In the sql server log, I found an entry sqlserveragent service stopping due to stop request from a user, process, or the OS...

Then log entry sqlserveragent ended normally.

Does not explain...

Thanks again for your explaination.  The BOL describes these hints, but I really did not understand them.  Yes, I will have to read more about the Dead Lock issue, the...

THANKS!!

I created an index for cTime.

What is the difference between ROWLOCK and UPDLOCK?

I am assumming since READPAST is also used, I will not get any deadlocks??

I still had error: Incorrect syntax near top.

I changed to use "set" and this seams to work but not much different from my original code.  If I have multiple applications...

The last sql statements provided:

declare @trackingCode char(4)

select @trackingcode = (top1 trackingCode

            FROM  tblSerial ( READPAST, ROWLOCK) ORDER BY cTime)

            UPDATE tblSerial

Yes, I had removed the @trackingCode variable, but it is mandatory as this is variable is used in more code in this stored procedure...