This can be due to any reason. Why don't you check for blocking to begin with.

select * from sysprocesses where blocked0

Table sample returns random set of rows. There is no guarantee for the number of records returned. It can be used for sampling

While top will give you the same set...

Only in 2005 its disabled by default for security reasons.

In 2000 you need to have sysadmin fixed role to use it.

Pls see the below link

http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx

Thanks pklotka. But I would stick to the table. It gives me control over which all servers to check among my long list of linked servers. Thank you for the...

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/a7e6bcea-a593-4e29-939e-e76fe87dfce3

Please see the above link can help.

I have achieved the same using cursor. But sure of course there might be an easier way.

Did you check your error log/event log for timeouts or any other errors?

Have you tried manually growing the file?

Configure alerts for every errors with severity greater than 17- to start with

Ravish,

I think you should put it in the connection string

http://www.sqlservercentral.com/articles/Administration/worstpracticebadconnectionstringsandbadinfoinsyspr/802/

(I am not sure this is what you are looking for)

Thanks Tim.

I was wondering how it just stopped after restart.

My tempdb is pre - sized. I think the messages might have started after it filled the initial size. ...

Thank you all for your help.

But now the main cause of concern is no more there. I no longer get the IO warnings after a fail over. I think...

Kailash,

If you are looking for a kind of undo ctrl+Z for committed data, its not there in SQL Server

You can get the data back provided you are taking regular backups,...

Yes try to give more info if possible.

By the way if you need something to start with, Use activity monitor for blocking, use system monitor and sql profiler to...

Yes the best place to do this is crystal reports. You can use grouping in crystal reports based on tenants. And the repeated column can be placed in detail section.