Viewing 15 posts - 31 through 45 (of 72 total)
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...
December 10, 2008 at 5:04 am
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...
December 5, 2008 at 3:16 am
yes, tried that and still get no more than the one line error which gives nothing away.
December 4, 2008 at 2:11 pm
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...
December 4, 2008 at 3:35 am
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...
November 26, 2008 at 6:43 am
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...
November 19, 2008 at 3:27 am
Thanks Perry! That was it. I was stopping the trace but not closing it.
November 19, 2008 at 1:26 am
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...
November 18, 2008 at 8:43 am
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...
October 23, 2008 at 1:38 am
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...
September 13, 2008 at 2:58 am
I did look at http://msdn.microsoft.com/en-us/library/ms189871.aspx but sp_configure doesn't seem to be covered.
July 24, 2008 at 11:56 am
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...
July 3, 2008 at 12:55 am
Thanks for the replies. The OPENROWSET method worked perfectly.
June 23, 2008 at 8:16 am
Viewing 15 posts - 31 through 45 (of 72 total)