Everything was working fine until suddenly this problem appeared from  
nowhere:
Boot up the pc and go into SQL Server Management Studio.  The database is  
present and the data can be accessed.

I've noticed that if you have model and tempdb to different compatability
levels and restart the sql instance, the value in sysdatabases (cmptlevel)
does not get changed correctly.
Here's how to reproduce:

kindly someone post a simple java programme that will connect to sql
server database and excute some queries on table in database.
regards

We have a .NET 2.0 web application.  Occasionally, we get the following
error below when we are doing performance testing.  It is not consistent and
only happens every once in awhile.  We are using TCP/IP and only have one
instance of SQL running.  We do specify connection ...

I am trying to reinstall SQL 2000 on to a laptop running WIN 2000 Prof (SP4)
During install of SQL 2000, setup aborts and when checking the sqlstp.log
file we get following messages :-
Thanks

Can any gurus please tell me what the expected locking behavior of sqlserver
2000 and 2005 is when I have two jdbc connections (each from a different
jvm), taking part in the same XA global transaction but with different
branches. Do the branches share locks (tight coupling) or ...

hi, first my english is so sort, sorry
my problem is the following:
I try to make this example:
import java.sql.*;

   I have an application that uses ADO.Net (2.0) to connect to SQL Server.
We've never had any problems connecting to SQL Server 2005 using this
application, but one client has had problems and the error he gets is of the
type "General Connection Error...[Microsoft][ODBC SQL ...

We have a situation where multiple-random client connections to SQL server
get disconnected.  The workstations are not consistent, the time is not
consistent, and the functions being run are not consistent.
One thing that we can reproduce is that sometime, but not always, if a

I am trying to add an Access database as a linked server in SQL Server
2005.
For a "regular" database, everything works fine. BUT (there's a
but...) the database I'm trying to access is a "read-only" database

I have a webservice I am creating. I am needing to connect to a SQL server on
a different machine using SQL authetication. I have the connection string
located in the machine.config. Could somebody give me a sample of how to use
that connection string to connect to the database ...

I installed msde fine
I installed webadmin fine
I try to fire up webadmin from the server's local interface...I get Access
denied to the path "I:\Windows\Microsoft.net\framework\v1.1.4322\Temporary

I have a situation where I have linked tables from SQL Server in
Access 2000 using ODBC.
I am using these tables via a complex query as the record source for a
form.

I am using the following connection string from Access vba to call stored
procedure. However, there is error in the connection. When I am checking the
same connection from the control Panel using dsn, the connection shows
success. I would appreciate if someone can tell me what's ...

We have multiple SQL 2005 instances on SAN.  Does any one know how to
configure JDBC (JVM 1.4) to connect to an instance of SQL 2005 SP1 on
SAN?
Do we need to update any driver to connect to SQL 2005?