What do you get from SELECT @@servername;

Well, I am not sure about that - let me take a look around and see if I can find something.

Generally, I have found the best method is to just...

How exactly did you get those maintenance plans onto the new 2008 system? Did you restore the msdb database from the 2005 system to the 2008 system?

If so, then...

Using read uncommitted is the same as using (NOLOCK) - and, you are finding out exactly why this is not something that you do to work around issues.

There are several...

For a simpler method, you can grant execute privileges on a schema. For example:

GRANT EXECUTE ON SCHEMA::dbo TO {role or user};

Now, if someone creates a new procedure - you...

Using Powershell installed on any system that has network access:

PS> Get-WMIObject Win32_Service -computer {computer} | ? {$_.Name -like 'MSSQL*'} | Select Name, State

You can then extend this to send email...

In 2005 - you have to add the Maintenance Cleanup Task to the maintenance plan and configure it. Sounds to me like that does not exist in the plan...

Glad I could help and you were able to get something to work.

ehlinger (3/1/2009)

---

Jeffrey,

You aren't missing anything. I just didn't explain the whole picture well enough. The reason it won't work to do filtering on the adjustments table is because...

I really don't understand why you even need the #PointPartners table. Since all you are doing is filtering that table where the AdjustmentName is like 'PP_%' - and, you...

I think I understand what you are trying to do, but I am not sure it is needed. Can you just create a new formatter procedure with the new...

Okay, so what have you tried and why does it not work? Read the article in my signature and post some create...

I ran into this issue before and found the only way to get this information was to get it from a server side trace. I was not able to...

Okay - wasn't sure, but since your are on SQL Server the EXCEPT operator is available and can be used.

SELECT REPLACE(col2, '\' + col1, '');