|
Home > Archive > MS SQL Server > November 2006 > "Internal SQL Server error."
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
"Internal SQL Server error."
|
|
| Mike C# 2006-11-28, 7:14 pm |
| "Server: Msg 8624, Level 16, State 7, Procedure p_get_LocalAuthor2, Line 58
Internal SQL Server error."
....and on that note, I'm going home.
| |
| Aaron Bertrand [SQL Server MVP] 2006-11-28, 7:14 pm |
| What does SELECT @@VERSION yield? What does p_get_LocalAuthor2 look like?
What is on line 58?
"Mike C#" <xyz@xyz.com> wrote in message
news:uOisHvzEHHA.3608@TK2MSFTNGP02.phx.gbl...
> "Server: Msg 8624, Level 16, State 7, Procedure p_get_LocalAuthor2, Line
> 58
> Internal SQL Server error."
>
> ...and on that note, I'm going home.
>
| |
| Mike C# 2006-11-29, 7:12 pm |
|
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:e66wS1zEHHA.3784@TK2MSFTNGP02.phx.gbl...
> What does SELECT @@VERSION yield? What does p_get_LocalAuthor2 look like?
> What is on line 58?
Hi Aaron,
Don't sweat it. This is a stored procedure that ran fine about 20 times in
a row on SQL 2000 SP 4. The 21st time seems to have been the charm. I
already checked and there's no KB articles that address this particular
situation (though there are a few that talk about "Internal Server Error"
under different circumstances that don't apply to my situation.)
BTW, Line 58 looks like this: DECLARE @s VARCHAR(50)
Cool, huh? Thanks.
| |
| Aaron Bertrand [SQL Server MVP] 2006-11-29, 7:12 pm |
| > already checked and there's no KB articles that address this particular
> situation (though there are a few that talk about "Internal Server Error"
> under different circumstances that don't apply to my situation.)
Most "Internal Server Error" issues are internal bugs that are fixed with
SPs or hotfixes. It may very well be a symptom that is fixed by a hotfix
that addressed a different system (not all bugs ever make it to the
knowledge base, so don't consider it to be gospel).
But, if you want to stay at SP4 and ignore the more recent hotfixes, you may
still continue to have this problem. If you can reproduce it on a second
box, especially after applying the latest hotfix, you may want to post a bug
on connect.
A
| |
| Mike C# 2006-11-29, 7:12 pm |
|
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:%23SYpze8EHHA.4016@TK2MSFTNGP02.phx.gbl...
>
> Most "Internal Server Error" issues are internal bugs that are fixed with
> SPs or hotfixes. It may very well be a symptom that is fixed by a hotfix
> that addressed a different system (not all bugs ever make it to the
> knowledge base, so don't consider it to be gospel).
>
> But, if you want to stay at SP4 and ignore the more recent hotfixes, you
> may still continue to have this problem. If you can reproduce it on a
> second box, especially after applying the latest hotfix, you may want to
> post a bug on connect.
Thanks, I was just venting :) For now I've rebooted the box and it
suddenly works again. Go figure. I'll probably post a bug if it happens
again.
Thanks again
| |
| Aaron Bertrand [SQL Server MVP] 2006-11-29, 7:12 pm |
| > Thanks, I was just venting :)
You should consider a blog.
Here, just about everything is presumed to be a request for help.
A
|
|
|
|
|