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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2001-02-06 : 17:04:06
|
Mark Adair writes "Environment:
NT 4.0 SP 6a SQL Server SP2 Quad Processor Server
If I run a trace through profiler I am getting a huge amount of Exceptions with an error code of 1203. After seaching the MS Support Site I found an article that relates to Bug 56266. The suggested work around is to set max degree of parallelism to 1. Or to upgrade to SP3.
I am reluctant to upgrade to SP3 as the CRM Product running on the SQL server is not yet qualified with SP3. I understand that it is a matter of time until SP3 will be qualified with the product.
My question is, are you aware of any other issues that may cause the 1203 error to occur so often on SQL Server SP2 as all other MS Documentation relevant to the error are for v6 or v6.5 not v7.0.
Are they any other issues I should be a aware of or any configutration changes I can make to try and remove the error without going to SP3.
The server has not 'hung' simce making the configuration change but the error still occurs in the trace file.
Thanks for your time and your help" |
|
|
|
|
|