Just go through the process of setting up Log Shipping in the GUI of SSMS and instead of hitting Ok to apply the action click the Generate Script > New...

Interesting. Where are you looking at getting a PhD in a DB-related field? For that matter if you don't mind me asking, is your Master's degree DB related?

I believe so. In patching a SQL 2005 cluster you have to patch the active node of the cluster and the cluster updates all nodes at the same time.

In SQL...

I would start off with sending a test e-mail through Database Mail. That should test that your Database Mail profile and functionality is working as expected. Then double-check that your...

Did you ask the sysadmins of the application if they were running any jobs/queries/reports during that timeframe? Is there a log for the application that will let you know what...

I then go to the SQL Server logs and view the current log.

At the same time when I received the email that the job failed I am able to...

Can you elaborate on what you mean by SQL is running slow? Specifics? You state that it is slow but there are no long running queries found.

I think Gianluca hit the nail on the head there. The AD administrators could have a GPO in place which is overriding your RDP preferences. We do this where I...

Then the problem...

Is the account that you are running the SSIS package from the same one that you installed/configured the Oracle client from? If not it could be a path issue.

Also, are...

Joie Andrew - I don't think there's a way to reset the password from the application other than the change password option each user is given on the login page...

I just reread the post. I meant to say reset the credentials for the SQL Server Agent service in SQL Server Configuration Manager.

When you have a cluster all of the servers, or nodes, of the cluster that can own the cluster resources will need to have the accounts setup properly for SQL...

A lot of memory showing up being used by SQL is normal. SQL will reserve what it can and show that memory as being used in Task Manager. If your...

Can you post a screenshot of the error that you are getting? Also, is anything listed in the SQL error log or Windows Application Event Log? You can access the...