Please check the following article from microsoft as it applies to 2005 as well.

How to resolve blocking problems that are caused by lock escalation in SQL Server

http://support.microsoft.com/default.aspx?scid=kb;en-us;323630&sd=tech

Hope this helps.

To my knowledge, one reason for this is MCAFee Virus Program.

MCAFee creates problem with Windows-XP but not with Windows 2000.

If MCAFee is installed, then uninstall that and try using another anti-virus or think...

Yesterday I resisted posting here, to wait and see how others respond to Fallen Angel and also not to pick anyone in particular for my comment after someone say sorry.

Today to Steves...

You can try the update as shown below. 

You can also wrap 2 statements in one  

BEGIN TRANSACTION...COMMIT TRANSACTION

if you really want the change to be atomic.

Begin Tran

UPDATE workrequest...

Soumya,

You can accomplish further operation Insert/Update/Delete

 on Select result using

1. Cursor   or

2. While loop using temporary table to hold your select output.

Better you provide more details of other operation that you...

To make data readable,this is how the conversion of data takes place

from sysjobs and sysjobhistory

SELECT sj.originating_server, sj.name,

--What is it in English

CASE sjh.run_status

WHEN 0 THEN 'Failed'

WHEN...

No query to answer.

Category : T-SQL

Question - Worth 2 Point(s):

Assume that the column and table names are correct and that OrderDate is a dateTime column. What is wrong with...

Go through the details given in following article.

SQL Server Exercise: Rebuild and Restore Master Database

http://www.dbarecovery.com/restoremasterdb.html

Hope this helps,

With 100 users using intranet application I cannot think of to many transactions generated in small interval of time.

How often you are taking log backups ?

Very high volume of transactions,...

Better avoid running optimization  job during time of alert.

Check the size of tempdb as well. If tempdb is on another drive say c

and there is no space for growth...

Hi Vishal,

Just now I have sent you an email for the same.

Thanks,

Thank You Steve for appreciation.

This is wonderful site and I highly acknowledge your Sql server skills and writing.

I would like to have your insight in one of my question here...

As your Db is 9 Gb and also it looks like you are having enough transactions that generate sizable log.

To move the database Backup DB --> Copy-->Restore DB

with move option is safe practise.

Better avoid temptation of detach & attach db option.This is last available option not the preferrred...

Copy Of Sql2000 backup to Sql2005 and Restore as 2005 db will work fine.

In Output of restore, you will find message- conversion of 2000 db [8.0] to 9

When you think of...