I did a right click job--then view history and saw the job. below is the failed description.

Error message

Executed as user: IHS\SqlAgent. Invalid length parameter passed to the SUBSTRING function. [SQLSTATE...

but when i run that script it displays 0 rows. but is there any other place where i can see the detailed logs. I mean the actual l,ogs. please help...

thanks a lot. and is there any other way to see the log, or aqny other location where the logs are saved?

It shows :- 9.00.1399.06 RTM Developer Edition

i also restarted the server. but shows same thing SP2 not SP3.

where are all the gurus??????????????

Is there any one can help me please?

Thank you all, but as of now i only want to see if something is locking and i am sure that these scripts well surely help. Thanks again.

thanks. and anything else i can do if i can find a lock or some more tricks to check lockings and how do i deal with it?

is there any one who can help me please??????

Thanks. i really appreciate your help.

OK so once again if i have below verison

Microsoft SQL Server 2005 - 9.00.3186.00 (X64) Aug 11 2007 05:31:24 Copyright (c) 1988-2005 Microsoft Corporation Standard...

so if i have SQL Server version

Microsoft SQL Server 2005 - 9.00.3239.00 (X64) Apr 9 2008 22:41:28 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)...

so you mean that there is no difference between Hotfixes and SP3 since SP3 will have all the hotfixes.

am i right?

can someone help me please ..............