If you log on to the server that you are issuing the xp_cmdshell command to, you will see in the task manager that calc.exe is running. It appears to...

The plan does work sometimes. Perhaps 1 in 5. My client tools are a CU behind but as the plan works sometimes and most of the other maintenance...

yes, tried that and still get no more than the one line error which gives nothing away.

I recently tried rebuilding the maintenance plans but I'm still receiving this error every night. I've also tried adding SET NOCOUNT ON to the beginning of each step in...

It's actually the connection-level setting which is on by default - my mistake. My problem is that even after both of these settings have been set to on, when...

This is still happening, unfortunately. These are the two separate errors that I receive from time to time:

"failed with the following error: "A severe error occurred on the current...

Thanks Perry! That was it. I was stopping the trace but not closing it.

Thanks but not very useful when trying to remember what the file is a few months down the line! This was working until yesterday so I don't know what's...

Thanks for the reply. The maintenance plan history is where I got the error message from. The SQL Agent job history was even less helpful, saying "The step...

I do use the escape button but it's just annoying that I now have to press escape in the middle of typing of scripts. I now have to spend...

Both the correct answer and an error is returned:

Msg 232, Level 16, State 3, Line 2

Arithmetic overflow error for type int, value = 2147483648.000000.

I did look at http://msdn.microsoft.com/en-us/library/ms189871.aspx but sp_configure doesn't seem to be covered.

Perfect, thank you.

This can be configured using the Affinity Mask server option. Run sp_configure (with Show Advanced Options on) to see this option, or right-click on your server in SSMS and...

Thanks for the replies. The OPENROWSET method worked perfectly.