Hi,
I'm new to hibernate, a work with sql server and i'n now involved in a project where they use hibernate and java to access a sql server 2005 instance. When profiling the database a can se that there is a lot of traffic using the old system procedures sp_prepexec and sp_unprepare.

Is there any other way to access sql server other than using these old procedures? What about cursors and set based operations, is there a setting you can use to force the use of data sets instead of cursors?

Regards
Michael