Without knowing your environment it would be difficult  to make a argument about what should or should not be done

Update ...

My client was SP4 and the database is SP3 not sure if this has anything to do but once I change clients to an SP3 client all seems to...

It seems too easy to be true but this has worked for me consistently.

Even so when you have an oracle background.

The problem was bad data.

Thanks for all your suggestions and your time

The present server is a dedicated server with a single database but the other which passed the test has 40 DBs do not ask me why?

That does not eliminate a...

Could not agree more.It does not take a lot to insert data into a table does it ?

Did the event logs/application logs give any more information

Mike

The concerned  tables were moved to a different server and everything worked just fine.

It is time to look into what patches and stuff were applied on the server .

Thanks

CREATE VIEW dbo.DEFECTS

AS

SELECT DISTINCT

                      TOP 100 PERCENT CONVERT(SMALLDATETIME, dbo.NH_NONCONFORMANCE.NH_RECORD_DATE, 102) AS [Record Date],

                      dbo.ND_NC_DEFECT.ND_NC_NUMBER AS [NC Number], dbo.ND_NC_DEFECT.ND_INTERNAL_NO AS [Internal Defect Number],

                      dbo.ND_NC_DEFECT.ND_LOCATION AS Location, dbo.ND_NC_DEFECT.ND_CLIENT AS...

Thank you.Seems trivial does'nt it

Mike

Thanks Brain

But how do I query syslogins without being in the master database

See if this helps

http://support.microsoft.com/?kbid=891311

Mike

Have not done it but parameters changed by an sp_configure do not need a restart of sql server

Mike

Probably not a faster way but I check the log files for errors

Mike

Are you shrinking very often?That has been known to cause issues

Mike