Please check the Maintenance Plan history for more information. Here is a screenshot.

Also you can add an output file to the job step which will log the job execution. Here...

You may find this script[/url] useful.

Ravi,

Please note that the...

To add to it, you may find this "Read me" useful.

It is a best practice to fail over all resources on to one node and install the service pack. Also ensure that there are no users logged on to the...

You may find this link useful.

Check if this post[/url] helps.

You can make use of sys.dm_tran_locks DMV to get that information. Here is an example.

This article has a good overview of Troubleshooting Performance issues in SQL Server.

I am not sure how the monitoring tool that you are using the Blocking Process %. You may query sysprocesses, sys.dm_exec_requests to find more information about the blocking processes. This...

It does not install SQL Server Client tools (SSMS etc). It installs "Microsoft SQL Server Native Client" which is the bare minimum installation.

I have not come across any issues after upgrading to Windows Server 2003 SP1 to SP2. However the Windows Admins would have performed this on a test box hosting SQL...

You are right. If there are no groups configured, you can click on "initiate failure" for a particular resource.

You may find redgate's SQL Monitor useful. As per this page, it supports "most mobile" devices. It should support Android devices as well.

You can make use of Microsoft SQL Server 2008 Feature Pack which installs only SQLCMD.