Nigel - that is just one of the reasons we ask for the questions to be posted the way we do. This way we can test a solution that...

The only thing I can suggest is remote into that system and verify that you can access WMI. I have seen things like this when WMI was not working...

Based upon your table definitions and sample data (thanks) this will work.

Update #propval

Set str_val = (Select CustomerCode

...

And, if you really think you have to use nested cursors - review the following article that describes a couple of ways of optimizing cursor operations:

http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/21/curious-cursor-optimization-options.aspx

As others have already said...

Fresh? You want to use fresh chops? Come on - you need to age...

Open the Maintenance folder in Object Explorer - right click on your maintenance plan and view history. This history will show you what step in the maintenance plan failed.

You can use EXCEPT to compare your tables:

SELECT {columns}

FROM db1.dbo.tablea

EXCEPT

SELECT {list of columns that match other select}

FROM db2.dbo.tableb

This will return a list of rows...

Review the article I link to in my signature on how to post a question to get a better/faster answer. Providing the create statements, insert statements for sample data...

I cannot believe you recommended a cursor to solve this issue. One of the previous posters already posted a way to do this using EXCEPT.

If you want to see...

You can get the object using the objectid column - but, if you want the actual stored procedure call you need to get it from a trace.

I have to agree with Jack - this really does not make sense. The cursor is defined to select two values (Product and Variance).

You then create a cursor over...

Maybe meteors are a bigger threat for you, but for me I am more worried about the aircraft taking off and landing next to the...

You can use the information schema views or the system table sys.columns.

I use Redgates SQL Compare to perform these kinds of comparisons. There are other tools available that do the same thing, some are even free.

Lookup CASE statement in BOL. General outline is:

CASE WHEN {expression} THEN {value}

WHEN {expression} THEN {value}

ELSE {value}

END