It depends upon application or setting of tool that you are using. If you have configured to use named pipes then it should be enabled obviously. And same for TCP/IP....

I have found some possible solutions, please check these

Verify that your network name resolution works.

Verify that the servers can communicate with one another by name, not just by...

Thanks for submitting the solution here also.

I would suggest that please also have a look at http://support.microsoft.com/?kbid=873160

Go to surface area configuration as shown and configure there.

Jerry, i have found it interesting to use your second idea of using sp_helptext sp_fkeys. Please guide me further that how to implement it for code customization?

For a report application, i have to get table names where foreign key from a table is being used. For this purpose i was looking an optimized way to get...

You may check msdb.dbo.backupset. There columns like 'is_damaged' may help you.

For time being, while tracing the source, you may change recovery model to simple. This will let you out of this problem until you trace the reason.

For some basics for monitoring SQL Server 2005 you may visit my SQL Server blog (DBDigger)

If you declare a transaction then you need to commit it. In case of ordinary batch without a declared transaction you do not need to commit explicitly.

Look for use of 'INSTEAD OF Triggers'. As triggers are of two types after and instead of. in your case 'instead of trigger' may work.

First take transactional log backup of your database. It will truncate inactive transactions from log. Then shrink the database and it should be reduced in size.

Are u using wizard for maintenance plan or designer?

Have you confirmed that SQL Agent service is running? And please also tell that either you are using wizard or designer for creating the plan?