Are there any published benchmarks available on comparing Microsoft's
JDBC Driver for SQL Server with other JDBC drivers so that I can
validate some results acquired in our testlab.Surprisingly ISVs did
much better than Microsoft in this area. The following table summarises

I have set up applications in Access and am now starting in SQL Server.  I
have taken a SQL class, but it did not cover starting from scratch.  Our IT
dept set up a blank SQL database for me and gave me all permissions, but I'm
unsure of how to proceed.  Do I need some sort of an ...

anyone knows how to verify if a linked server is active only using SQL code?
This question is because I need to check if a created linked server is ok to
perform actions on it.
Many thanks,

dear members
we have a program that its database is SQLserver2000  that installed on a
computer with ' MIS'   name.the type of  SQLserver installation is mixed mode
(not Authentication ). so , 2 weeks ago the program did run on all of the

I am having my SQL Server 2000 with SP3 service pack on an Windows O/S 2003
server without any service pack. My client application was able to connect
without any problems.
Now recently I have upgraded my SQL Server 2000 with SP4 Service pack and

This problem sounds like a problem of fulltext module, but it's not.
I'm using SQL Server 2005 Jun CTP on Windows 2k3 server
through MS SQL Server JDBC Driver SP3
from J2EE 1.4.2_08 on Windows 2k.

I'm actually satisfied with the old driver and the new
driver. They both run against 2000 and 2005 (sql express).
I stumbled against the new naming: staring to a bunch of
characters an being able to use the new driver only after

Hi I recently installed a copy of SQL Server 2000 and was unable to connect
as my SQL server gives me the message "Acess Denied SQL Server doesnot
Exist". I did use all the trouble shooting help but couldnot rectify it. The
probelm seems to be with my logon. I am starting it with ...

I'm trying to connect to a local SQL Server 2000 'Personal Edition'
running on Windows XP Professional. I've tried everything, and
searched the forums for similar problems, but I can't get the
connection to work... :(

I would like to know if there is anyway of retreiving an entire column of
data from a resultset into say an array or a vector.
e.g. If the resultset contains columns ID (int), Name(varchar), age(int)
then I'd like retrieve the ID values from each tuple in one go into say an

Are there any updated docs for the SQL Server 2000 Driver for JDBC since
December 2002?  Anyone got any good links or resources?
Thanks!

Hi, i have some applications that use a sql server user to connect to
databases. Sometimes i Check the las batch time in enterprise manager to
see if the connection is active, and the date is expressed like this:
"01/01/1900 12:00 am"

Which ports are necessary for SQL communication??  I have a test environment
with a web server and a separate db server and I want to shut down any
unnecessary ports on the web/SQL server.
Any advice is appreciated.

I am trying to insert 75000+ records into a table via a stored procedure
(the table is empty) - the information for all those records is contained in
an xml document that is passed to the stored procedure in a string. I am
using openxml to read the xml data and to insert the ...

I'd like to know how good is the Microsoft JDBC last version (SP3 I
supposed) . Is this driver RFC compliant? Is the driver compatibility's (
with application software) good?
I've got some trouble with the Sunopsis's application (wwww.sunopsis.com).