This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hi All, I am trying to call a system stored proc from SQL Server 7.0 in order to set the Truncate log on checkpoint to a value set by the user. I am this close to getting it <bill holds his thumb and index finger really close together> but can't seem to get it to run. It keeps throwing an exception. Here are the details: This statement works perfect when run directly against the SQL Server database using a query tool (MS Query Analyzer): <PRE><CODE> sp_dboption 'pubs', 'trunc', 'false' </CODE></PRE> WHERE 'pubs' is the database name. This also works: <PRE><CODE> sp_dboption pubs, trunc, false </CODE></PRE> ALL PARAMETERS are nvarchar
This is the JavaJDBC statement I am trying to run:
Can anyone help me out here. I have been 'playing' with it a good part of the afternoon trying to solve this, and I am about to look like the 'Bad Day' guy kicking his monitor across the room. Any help would be greatly appreciated. BillR </PRE>