The SQL Server 2005 JDBC Driver reports stored procedure names differently to
previous versions.
Printing the results of a call to DatabaseMetaData.getProcedures() shows the
procedure name in the <procedure name>;<number> syntax.

on a very popular slide with new features of SQL Server 2005, I saw
"VIA Support" as a new key feature for the SQL Server Engine. But I do
not get what that is. I read that this is the protocoll that SANs use,
and also is the API that SANs use.

I installed SQL Server on my PC and it has been running fine for a few
months.  Now I cannot start it but get this message:
-------------------------------------------------------------------------------------------
An error 1059 - (The Service did not Start due to a logon failure) ...

I have an application that needs to to talk to MS SQL Server 2000.
When I connect from a client machine, I am getting db-library network
communications layer not loaded.
What component is it missing?

I've been tasked with investigating different methods of achieving database
redundancy.
In doing so, I'm currently in the process of writing a test application to
prove that Database Mirroring in SQL Server 2005 is a suitable solution.

I am new to the linked server concept and I'm having trouble with the
following scenario:
Users are trying to run a report from Reporting Services whose data is
supplied from a stored procedure. The stored procedure gets its records

I am having problem connecting to a database using EM or Query analyzer. Both
applications start up fine. When I click on the database folder to expand it
in EM or the drop down in Query Analyzer, both applications hangs and nothing
happens. The SQL services started fine. Please ...

A User currently having a problem with an Access 2000 application that uses
Linked tables to connect to an SQL 2005 database. The user receives the
following message:
Connection failed:

I have a local server I just upgraded to 2005.  Everything went well.  But, I
also have a remote sql 2000 server I still  need to connect to.  Can't seem
to get the tcp/ip connection to old server to work.  Go back to old 2000 tool
and it works fine, but I'd prefer to stay in one ...

I am using MS SQL Server 2003 in a server running Windows Server 2003.
Workstations with Windows 98 Second Edition cannot connect through TCP/IP
ODBC link, workstations with Windows 2000 and Windows XP can do so. What can
I do? Is it possible to connect MS SQL with those types of ...

one of our customers had a server crash. So I recovered the database from
backup and integrated it successfully into another sql server. I'm able to
connect through DSN file. Tests ok but the application which should work with
the database seems to have problems to read or ...

I'm having this problem, I'm trying to run a query that consists of six
tables and one view (all joined together)
When I run it without anything on the where (or just one criteria in the
where clause) works just fine, but if I run it with two criteria in the

I have a problem with getting the error code from the callable statement.
I declare position 14 in the callable statement as an INTEGER for the error
code. The store procedure runs and comes back, but I receive this error when
I try to access the data:

"
PuAdoConnection As ADODB.Connection
...
Set PuAdoConnection = New ADODB.Connection

I've installed SQL2005 on my local machine. And there is another SERVER which has install both SQL2000 and SQL2005. I can use my local Management Studio to register the SERVER\SQL2000 instance but I cannot register SERVER\SQL2005 instance.
How can I register and connect to the ...