RE: 2005 JDBC Driver against 2000 Server can't "UPDATE STATISTICS tabl
- From: evanba@xxxxxxxxxxxxxxxxxxxx (Evan T. Basalik (MSFT))
- Date: Mon, 03 Apr 2006 16:28:27 GMT
Can you post your code?
--------------------
Thread-Topic: 2005 JDBC Driver against 2000 Server can't "UPDATE STATISTICS tabl
thread-index: AcZShHK57pBZevu/ShKVbO3EowF0/Q==
From: =?Utf-8?B?S2lt?= <Kim@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: 2005 JDBC Driver against 2000 Server can't "UPDATE STATISTICS tabl
Date: Tue, 28 Mar 2006 08:27:04 -0800
Message-ID: <EF10655E-648B-47A0-992F-5D8FCB0344BD@xxxxxxxxxxxxx>
Using the latest 2005 sqlserver jdbc driver against a 2000 SQL Server, I can
no longer execute this statement: UPDATE STATISTICS KimsTable; I get the
error message: com.microsoft.sqlserver.jdbc.SQLServerException:
UPDATE STATISTICS statement not allowed within multi-statement transaction.
Do I need to set something on my SQLServer 2000 server, in order to execute
statements like this? (This worked with the previous JDBC Driver)
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
.
- Prev by Date: RE: failed to resume transaction error
- Next by Date: Re: lock_timeout
- Previous by thread: RE: failed to resume transaction error
- Next by thread: Re: lock_timeout
- Index(es):
Relevant Pages
|
