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 |
|
Ganeshk
Starting Member
6 Posts |
 Posted - 2008-08-29 : 09:39:03
|
| Hi All, I am getting the error below when executing some unusual queries on analytics DB. Normal select and update operations are fine..Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.Microsoft suggests to apply latest hotfixes. I have applied cumulative update package 2 last week for ss2k5. and that is the latest, i think. is there a workaround to get rid of this? would appreciate your quick response. Best regards, Ganesh K. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-29 : 09:44:44
|
quote:
Originally posted by Ganeshk
Hi All, I am getting the error below when executing some unusual queries on analytics DB.
SELECT @@VERSION works fine for me.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Ganeshk
Starting Member
6 Posts |
Posted - 2008-08-29 : 10:07:38
|
| Dear Peso, you took it otherway. I know, i have the latest updates on. I mean to say, what are the workarounds when this error message comes? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-29 : 10:10:24
|
Do you expect me to KNOW what query you tried that made SQL Server scream of pain?Especially when you write "unusual queries"...
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Ganeshk
Starting Member
6 Posts |
Posted - 2008-08-29 : 11:09:09
|
| Thanks Peso, for getting back soon. Actually, the 'unusual queries' are reindexing,dbcc checkdb,dbgrowth queries, or compiling some sprocs. Hope, you have a better insight now! |
|
|
|
|
|
|
|
|
Msg 0, Level 11, State 0, Line 0