On a version of SQL Server 2008 with Service Pack 1 applied (on Windows Server 2003), I am finding that when trying to run a bulk number of jobs using the sqlcmd command, one of the jobs will randomly fail to run with the following error thrown in the command
Sqlcmd: Error: Internal error at ExecuteSqlCmd (Reason: Unspecified error).
I've found that each time the batch of jobs is run, a different one will fail to run each time. It seems to be completely random which one will fall over, but you can guarantee that at least one will fall over each time.
I've tried numerous websites to find an answer and no luck so far. There is a hotfix which has been released for this exact same problem (http://support.microsoft.com/kb/2121407/) but this is only
for R2 and so cannot be applied to my installation and we're not in a position to move to R2 as yet.
Is there a fix available for non R2 users for this?
View Complete Post