I have a two Linked servers in a database. One of them is colocated in the
same lan and the other server is across the country(California to Florida).
We have a dedicated    T1's(8 of them) between these two location.  I have a
stored procedure  that decides which server to  ...

For some time, I have been trying to determine why we are getting
timeouts under certain conditions using an A2003 front end, SQL2000
backend.  I have recently seen several quirky conditions related to a
too-low setting of maxlocksperfile.

I just installed version 2005, and it is co-existing with
an instance of 2000. I am trying to test the remote connection string from
an ASP .Net page which works fine already in 2000. However it does not work
in 2005.

I just installed version 2005, and it is co-existing with
an instance of 2000. I am trying to test the connection string fro an ASP
.Net page which works fine already in
2000. However it does not work in 2005.

I want to run a database creation sql script.  The problem (I believe) is
that I have to specify the database I wish to connect to when connecting to
the server (ADO).  Should I specify the Main database?  Or is there a way
around this?

I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.

I am using Commons DBCP to pool my sqlserver database connections.
Sometimes there is just an hourglass cursor when trying to access my
application - looks like there are no free connections available.
Am I doing anything wrong in my code? Should I be closing the

I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql"  ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").

Is it possible and if yes how to install just a SQL Native Client on a
client machine.
This is for a SQL Express Edition installation.
Mike

I have installed SQL Server 2005 CTP/Trial Version.  
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC

Hi, All,
I got a problem with linked server, I cannot fix it, if anyone can help will
be appreciated.
The problem is two instance of sql server in one machine, A and B, in A made

We are running a client program on NT 4 using SQL-DMO objects. We have
upgraded the server (on another box) from NT4/Sqlserver 7 to WS
2003/Sqlserver 2K. Our Sql-DMO program is now returning an error.
We would like to avoid to upgrade the NT4 client box for stability reasons.

My hosting service is supplying the space on a MS SQL ODBC server for my
phpBB forum so I don't have a SQL server CD-Rom. Is it possible to only get
the Enterprise manager not the sever package? If not where do I purchase this
at?

Microsoft OLE DB Provider for SQL Server error '80004005'
TDS buffer length too large
how can i solve it ?

Hi, friends,
When I used ADO.Net to connect to our SQL Server, I got the error saying:
Login failed for user 'mscn'. Reason: Not associated with a trusted SQL
Server connection.