Following were the messages from event log before sqlservice is stopped:

1. One of my backups failed due to following error :

The operating system returned the error '64(The specified network name...

Thanks for your replies............

1.Integrity checks(check db)--------won't be done on the secondary database in case of logshipping and mirroring

2.Maintenance tasks(index rebuilds) ---will be done on the secondary database in...

My databases are in sqlserver 2005 and 2008

Thanks,

Vamsy

I have one more question on indexes

Let say I have one table 'test' with columns fid,fname,faddress,cid,cname,caddress with

one nonclustered index 'f' on fid with fname,faddress included and another nonclustered 'c'...

Thanks Gail.

Thanks for your reply Grant...

We are experiencing deadlocks frequently.

We have

1.Read committed isolation level

2.Indexes are placed on all required columns

3.Index Rebuilds are running as maintenance tasks.

Please suggest me how...

Pradeep,

Thanks for your reply.

I need the values that are passed to the parameters of stored procedure at the time of deadlock.

I read many articles on the deadlock but I...

Is there any other way other than using DML triggers?

Hi Pradeep,

Thanks for your response.

Can anyone please suggest me a solution on the above problem