Anyone seen Error 831 on SQL 2005?

[mrdenny]

When a stored procedure is run either via a job or manually this error is received.

Msg 831, Level 20, State 1, Procedure spr_ins_ACSTables, Line 98
Unable to deallocate a kept page.

Has anyone seen this before? It's SQL 2005 Enterprise Edition on Windows 2003 Enterprise is an Active/Passive Cluster.

If I run the insert statement that is causing the problem manually then it runs with no problem.

Does anyone have any ideas? I can't find anything on this error on MSKB, Google, MSDN, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

I have an update for anyone intersted.

As this was a SQL 2005 cluster I was able to move the SQL Service to the passive node, and re-run the procedure without error. I then rebooted the origional node, move SQL back and the procedure ran correctly on the normally active node.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com