We have tracked two of the Four instances of this problem to have happened exactly the same time that an ARCServe Backup was running.  This backup is run every two hours...

Thanks Sami, I forgot to mention that this worked on SQL Server 7.0 and stopped working after migration to SQL Server 2000.  I'll give your suggestion a try.  The only problem...

Hi Andy,

Thanks for the posts.

Yes, the insert is at the SP level and the code you suggest is simple and it will work - to a degree.  As I mentioned...

for_himanshu – We are not using any javascript, it’s pure html, please see previous post.

burton...

Hi David,

The "submit" is an HTML button.  All scripting is done Server Side with VBScript.  After a "submit" button is clicked, the insert is done and the page is then redirected to...

Hey mom,

My last posting was only to reply to the suggestion of "disable SQL Auth."  sa is not used anywhere.  Thanks for your concern.

Steve DiDomenico

Nashua, NH

Thanks Steve, I'll give that a try.

Thank you to all who replied.  For now, we cannot disable SQL Auth. as we have some System DSN's using mixed mode.  Some are used by Crystal Reports that need to get default...

Thanks Steve. Just so I understand, can you tell me what you mean by "Disable SQL Auth."  Does it have to do with the Authentication Mode?

Hi jima,

Thanks for defining "some other objects" as I was hoping you were referring to logins, roles, server jobs etc.

Also, thanks for the reminder, as I do understand the need...

Thanks so much for this info. I will study it.

Steve

Thanks so much for all of the input. 

As a newly appointed (inexperienced) DBA, I find great comfort knowing that there are experienced DBA’s on SQLServerCentral.com willing...

Additional Information:

I created a new DB with 2000MB for the .mdf and 1000MB for the .ldf. I left the default settings at 10% automatic growth with no restriction for...

Hi alzdba,

Thanks for the reply. I do not know how to set the Resovery model. My real question was in the first sentence of this posting. The rest was...

Is there a way to force off a User or Kill a process?

On the day I posted this question I received two responses.

1)I tried sp_who2. This tells...