| Mike Hodgson 2006-12-06, 7:12 pm |
| I'd never heard of it before, so I googled the message a found a thread
(http://www.tek-tips.com/viewthread....=1253359&page=1) that talks
about it very briefly. If the thread is correct then it would appear to
be a known issue with SQL 2005 that will be addressed in SP2 (I cannot
confirm this, but you may be able to find a SP2 fix-list if you search
around the web). SP2 has just recently gone to CTP. You can find out
about it on this page (http://www.microsoft.com/sql/ctp.mspx) & download
it here
(http://www.microsoft.com/downloads/...&displaylang=en).
However, bear in mind a CTP is pre-release software. Microsoft do not
officially support them, so be very careful about installing a CTP in a
production environment.
--
*mike hodgson*
http://sqlnerd.blogspot.com
morphius wrote:
>We have SPs that create our reports tables. Every 3-5 days we get the "unable
>to deallocate a kept page"
>Any insights to this error is highly appreciated..
>
>
|