Error Code

Server: Msg 8624, Level 16, State 3, Line 1
Internal SQL Server error.
I've looked at several KB articles.
1) http://support.microsoft.com/?kbid=885442
This doesn't describe my problem as the view does not have a delete.
2) http://support.microsoft.com/kb/290817
This does describe my probelm. I already have sp3 installed though.
3) http://support.microsoft.com/?kbid=830466
This also describes my problem. But the KB is old, April 2004, and I
would assume SP3 would have resolved this.
I didn't write the view. Someone from this forum was nice enough to
write it for me. I'm looking through it now and hopefully I can
understand it enough that I can learn from it and attack the problem in
a similar way. But I'm also curious if this might not be a SQL server
setting issue. Thanks.Hi
No, SP3a was build 760. The fix is build 852. Look at installing Build 878,
the highest publicly available hotfix, supported by PSS.
http://support.microsoft.com/defaul...kb;en-us;838166
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Won Lee" <nospam@.nospam.com> wrote in message
news:ObBBUnQIFHA.3336@.TK2MSFTNGP10.phx.gbl...
> Server: Msg 8624, Level 16, State 3, Line 1
> Internal SQL Server error.
> I've looked at several KB articles.
> 1) http://support.microsoft.com/?kbid=885442
> This doesn't describe my problem as the view does not have a delete.
> 2) http://support.microsoft.com/kb/290817
> This does describe my probelm. I already have sp3 installed though.
> 3) http://support.microsoft.com/?kbid=830466
> This also describes my problem. But the KB is old, April 2004, and I
> would assume SP3 would have resolved this.
> I didn't write the view. Someone from this forum was nice enough to
> write it for me. I'm looking through it now and hopefully I can
> understand it enough that I can learn from it and attack the problem in
> a similar way. But I'm also curious if this might not be a SQL server
> setting issue. Thanks.|||Mike Epprecht (SQL MVP) wrote:
> Hi
> No, SP3a was build 760. The fix is build 852. Look at installing Build 878
,
> the highest publicly available hotfix, supported by PSS.
> http://support.microsoft.com/defaul...kb;en-us;838166
>
Applied that hot fix and rebooted 2003 server. No dice. I'm at a loss
for what to do.|||Hi
Log a call with PSS. Looks like you have a live one there.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Won Lee" <nospam@.nospam.com> wrote in message
news:ehNX9BRIFHA.3776@.tk2msftngp13.phx.gbl...
> Mike Epprecht (SQL MVP) wrote:
878,
> Applied that hot fix and rebooted 2003 server. No dice. I'm at a loss
> for what to do.|||Mike Epprecht (SQL MVP) wrote:
> Hi
> Log a call with PSS. Looks like you have a live one there.
>
OK Thanks. Will keep everyone updated.