I was not able to connect to local sql server 2005 express database through
the ms jdbc driver, my local sql server 2005 server name is:
DENLAP0059987\SQLEXPRESS,
my java code is following:

I would like to pass array ( like java.sql.Array) parameters to my SELECT
query.
I have found syntax for T-SQL :
declare @test table( id varchar(50));

  I developed a windows application that connects to Sql server 2000, using
windows authentication and it works, able to retrive and other data process.
But when I used it on Sql Server 2005 Express, it was unable to retrive data.
What is wrong with it? How can I fixed this?

I am experiencing wierd problem:
My SQL server is on one PC, and the (Classic) ASP web application is on
another PC (let's call it AppPC). The code in ASP is trying to connect to
the MSSQL server, using standard OLEDB connection string:

I connect to SQL server using SQLDMO to update the database and make many
Other tasks. I installed SqlServer2005 on a test server and I got an error
using the connect method of SQLDMO.
Is SQL Server 2005 is 100% compatible with old SQLDMO?

Anyone can tell me on how to set up a linked server from MsSQL 2000 to Ms
Access XP ?
My Access MDB is a password protected database but doesn't use Workgoup
Security.

ls,
We run MSSQL 2000 on a W2K3 machine. There is an accounting software (Exact
Globe) that access its data by means of SQL. For some reason I can only
connect to the SQL server as ADMINISTRATOR. Though I created a group, put

I'm working with query anlyser.
Is there a way with code to transfare to another server?

Whats the best Java driver for SQL Server ? There are so many out there and
want to hear from you on whats the best ?
Thanks

how I can connect remotely to SQLExpress?.. I have enabled TCP/IP,  but it
does not work.
error:
....

Sql 2k enterprise on Win2k3 Advanced (both at SP4).  Large network, 1 Parent
Domain, 20+ child domains. (2000 Native).
Having intermittent trusted security issues with a couple of the child
domains.. When users try to connect to SQL server they get error:

We are trying to find out about the imported keys from an SQL 2000 database's
table.  However according to the DatabaseMetaData class the constant field
value for importedKeyNoAction = 3 and for importedKeyRestrict =1.  when the
foreign key which we create has update and delete ...

Using the DatabaseMetaData class’s method getIndexInfo seems to be returning
some strange information for the first result set object.  For example after
createing a database with one table and one index, then connecting to it,
getting the meta data and calling getIndexInfo() I ...

Hello together,
I've got the following: SQL Server 2005 Express & SQL Server 2000
The sql server 2000 has got a database with some tables, which I want to
show as view (readonly) in the sql server 2005 express.

2 servers SERVERA & SERVERB, are both SQL 2000 SP3a on Windows 2003 server.  
Named instances.  Use tcp and named pipes.
Everything worked fine when my desktop was Windows 2000 before.
I upgraded my desktop to Windows xp sp2 last week and then i started to get