I guess Lock Escalation is disabled for SQL Server Instance thus it’s resulting in multiple row / page locks and finally abrupt termination.

Please read following article, it explains the locking...

1) Posted Saturday, July 26, 2008 9:34 AM

2) Are you ready to pay for it?

10 pm: full backup starts - fb

10:15 pm: log backup 1 starts - lb1

10:35 pm: log backup 1 ends - lb1

10:45 pm: log backup 2 starts - lb2

11 pm: full...

Hope you are taking about this (assumption based on data mining forum):

http://en.wikipedia.org/wiki/Cluster_analysis

If Yes, please go through following articles as well:

http://www-users.cs.umn.edu/~han/dmclass/cluster_survey_10_02_00.pdf

http://social.msdn.microsoft.com/Forums/en/sqldatamining/thread/96f5c700-8de8-4921-8862-aee8585071a3

If No, please provide more details.

Posted Sunday, February 10, 2008 6:51 AM

Per BOL EXEC or EXECUTE to run a stored procedure is optional.

--Execute a stored procedure or function

[ { EXEC | EXECUTE } ]

{

...

Not required unless you are planning for SSRS installation on the same box.

I was not administering the Reporting Services (was helping Application Architect in debugging the issue as DBA). I believe following pointers might be useful to you.

Please Search for 'Anonymous' or...

•Stop / disable the services in SQL Server (& others) that you are not currently using. It will minimize the memory utilization.

•Also, provide min & max memory setting in...

Is there any particular reason for using Access Front End (except you are familiar with it)? I have used Access Front End but only if the backend is Access. There...

It’s not funny, its headache actually. I have seen this issue couple of times in import when NULL values appear as ‘NULL’ string. It very much depends upon which source...

Thus it’s fine in either way. It’s a matter of choice now.

However I shouldn’t expect any DML activates on Read Only database. But putting the database in simple recovery mode is not my preference. I hesitate to put database in any...

I have seen something similar in my last project so it’s faded image now. The reason for the issue was SSRS configuration where Anonymous Login was enabled (or was default...

I understand it. My point is shrinking the log will be more effective after log truncation.

Per BOL:

Shrinking can occur only while the database is online and, also, while at...