Viewing 15 posts - 76 through 90 (of 1,160 total)
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...
January 31, 2011 at 9:22 am
January 28, 2011 at 12:35 pm
ravisamigo (1/28/2011)
Yes, I have given full control access to that login under share and security tabs of that shared folder.Note: SQLServices are running under local system account.
Regards,
Ravi
Ravi,
Please note that the...
January 28, 2011 at 3:33 am
To add to it, you may find this "Read me" useful.
January 27, 2011 at 10:06 pm
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...
January 27, 2011 at 10:05 pm
You can make use of sys.dm_tran_locks DMV to get that information. Here is an example.
January 23, 2011 at 10:28 am
This article has a good overview of Troubleshooting Performance issues in SQL Server.
January 23, 2011 at 12:51 am
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...
January 22, 2011 at 10:18 pm
It does not install SQL Server Client tools (SSMS etc). It installs "Microsoft SQL Server Native Client" which is the bare minimum installation.
January 20, 2011 at 8:31 am
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...
January 20, 2011 at 2:52 am
You are right. If there are no groups configured, you can click on "initiate failure" for a particular resource.
January 19, 2011 at 10:12 pm
You may find redgate's SQL Monitor useful. As per this page, it supports "most mobile" devices. It should support Android devices as well.
January 19, 2011 at 10:01 pm
You can make use of Microsoft SQL Server 2008 Feature Pack which installs only SQLCMD.
January 19, 2011 at 9:53 pm
Viewing 15 posts - 76 through 90 (of 1,160 total)