SQL Server JDBC - 2005 JDBC Driver against 2000 Server can't "UPDATE STATISTICS tabl

Author

2005 JDBC Driver against 2000 Server can't "UPDATE STATISTICS tabl

Kim

2006-03-28, 11:24 am

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)

Evan T. Basalik

2006-04-03, 1:23 pm

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@discussions.microsoft.com>
>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@microso
ft.com>
>
>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.

Sponsored Links