First of all I would like to thank you for teaching me the the sp_msForEachTable stored procedure. I have other scripts that I have created a cursor on to...

Thanks

The table and view are in the same database. I did find more information on this issue. The user was trying to insert a new record into the...

David, Thanks for your help but I don't know where that is. I forgot to mention that I am running SQL 7.0. Please help

We are running SQL 7. We are putting together a business case for SQL 2000 though, but don't see that for 6 months or so

We are a sysadmin of the production server.

We did try a few other things. If we log onto another SQL Server/NT box and try to profile the production server...