Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rme8494
Yak Posting Veteran
98 Posts |
 Posted - 2007-07-20 : 13:45:50
|
| Hey Everyone,The code linked below returns an "Internal SQL Server error." error when I run it in Query Analyzer on my MSSQL 2000 server. Any ideas? It seems to have something to do with the date part of the subquery.Error:Server: Msg 8624, Level 16, State 21, Line 31Internal SQL Server error.Code:[url]http://codeshare.ulatu.com/jul85ff0[/url]Any ideas?RyanRyan EverhartThe New AT&T |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-20 : 14:22:02
|
is there any more detailed info in the sql server log file?
elsasoft.org |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-20 : 14:29:25
|
| What's sql2k service pack level on the server? |
|
|
|
rme8494
Yak Posting Veteran
98 Posts |
Posted - 2007-07-20 : 14:58:30
|
| SP4 is the current SP, and how can I find the logs?Ryan EverhartThe New AT&T |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-20 : 15:40:27
|
| Under management in em. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-07-20 : 16:38:10
|
| It seems unlikely that you actually posted all the code, since there are only 18 lines, and the error message points to line 21.If you are going to post the code, just post it on this forum inside code tags.CODO ERGO SUM |
|
|
|
rme8494
Yak Posting Veteran
98 Posts |
Posted - 2007-07-20 : 17:44:31
|
| Mike,Thanks for the post. I did post all the code that was relevant to the error I'm receiving. The rest of the code was simply blank lines and the declaration and setting of parameters.RyanRyan EverhartThe New AT&T |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-20 : 22:20:53
|
| Which line is line 31 in your post then? |
|
|
|
|
|
|
Internal SQL Server error on Query