yes i have named pipes and TCP/IP enabled.and also in server properties in security SQL Server and windows authentication is selected.

thanks a lot.

thanks a lot.

as far as i think i have to download

the second one

SQLServer2005SP3-KB955706-x64-ENU.exe

but making sure because this is on a prod.

ok thanks a lot. i was confused by that.

So when I run

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

It give the output as

9.00.4035.00SP3Developer Edition that is good.

But when I run

select @@Version

It give the output as...

thanks a lot man.

any clues friends?

I am using 2005 version and i understand that i have to copy that script that is in the agent job to the maintenance plan job box but there is...

can someone help me please?

available free space is 2%

no that's not the case. when other were doing it it was releasing some space and suddenly i was given the responsibility and i could not release any space. so...

But it worked when the others do it but this task was now given to me to shrink the database, and i could not release space. I don't know why.

But this script is for shrinking the transaction log files. and my trans log files are in D:\ drive and my data files are in E:\ drive so just concerned...

yes sir when i changed the job name from the real job name that i had it gave me the same result that i see in the job history. so...