I noticed when connecting to SQL Server using the SQL OLEDB provider that a
number of SET commands are issued.  In particular
SET CONCAT_NULL_YIELDS_NULL ON
is issued, and I'd like to change that to OFF.  I've set the database option

I hope I'm posting this in the right group.
I'm trying to connect to a network server running Sql Server 2005 Express
from vb 2005. I can connect to it when I use:
DATA SOURCE=<servername>\SQLEXPRESS;INITIAL CATALOG=<cat>;Integrated

Upon a client connecting to the server, is there an 'OnClientConnected'
-equivalent event on the server side that I can put some code to check who
has just connected or what application or workstation is connecting?   I'm
looking for some way to check for 'valid' client ...

I get sometimes the following error when my weblogic webapp try to upload a
file :
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
setting up static cursor cache."

I get the below error when I query a SQL Server database from my ASP.NET
application. It looks like the timeout is 30 seconds.
How can I increase the timeout?
Olav

I have a SQL 2000 server on a Windows 2003 server that i need to access with
a  different name from the same machine only.
I added a hostname in the host file and associate it with the ip 127.0.0.1
In a test enviroment works fine but when i try to do the same in the real

Does the new MS JDBC driver support the database mirroring features of SQL
2k5? Is there a way to specify the failover server to the JDBC driver? And to
have the JDBC driver handle the failover and failback?
Thanks, Adam

For version 1.0 of the JDBC driver, we made the decision to forgo the
Javadocs format in favor of having a more integrated help system formatted
as flat HTML files. However, we have received some feedback that Javadocs
would be the preferred format.

will a client application using ado.net get an exception if the command is
executing a stored procedure that does a RAISEERROR in its tsql?

I posted this in sqlserver.programming and did not get any responses.  Trying
again..
This bugged me in SQL2000 and seems to still be here in SQL2005. Here's repro
code to run on two SQL2005 servers:

I've a customer of mine asked me for a web hosting , and  internet site
contains a SQL database.
It seems to be very simple but  customer wants database at his office, so my
problem is what is the most suitable solution to make communicate web and

I'm planning run a batch ( c:\CopyBkp.bat ) in a basis daily-night,
basically it makes a copy of my full backup files on another machine
in the net. The batch runs fine executed from a cmd window,
but from Query analyzer (testing purpose) the instruction

I get this error when I try to execute "rs.isLast())" method from WSAD 5.1.2
base_v5 library.  I am currently using SQL Server 7.0.  I want to know if
there is a driver to let me execute that method successfully.
Thanks in advance

Has anyone had any success with linked servers and DB2. My DB2 knowledge is
very limited.
EXEC sp_addlinkedserver
@server = 'SERVERR2',

Win2003 SP1 + SQL 2000 SP3
Sometimes, i have to restart SQL Server, because new users (on their regular
PCs) cannont connecto to SQL. I have 100 SQL CAL licences, and 45-65 users.
Sometimes a user disconnects, change to another's one PC and can connect.