Hi sql server experts:
Does any one have a script that detect if local sqlserver cannot be connected.
Our sql server sometimes lock itself down due to memory problem. It does not
accept any local/remote connections until we reboot the machine.

A client is having a problem inserting data from his Access application.
When I opened a table via Enterprise Manager and tried to enter a record I
got this error:
[Microsoft][ODBC SQL Server Driver]The log file for database 'STSIData' is

I was hoping someone could explain a permissions "oddity" I'm seeing. I just
want to understand why it works when it doesn't seem like it should.
I have a fresh SQL Server 2008 Standard Edition install that uses Windows
Authentication. The name of the computer hosting the SQL Server ...

I need to run a SELECT using SQL Query Analyzer, that SELECT must join information from tables in two diferent servers.
A few days ago I could do it between two servers that replicate databases, but now I try that between two servers that never replied.
   * Srv1 (SQL Server 2000 ...

I have a general question here, writting application to connect to SQL server
DB, which one is faster and reliable in term of connection?
Some people use hostname, and some use IP address. I would like to know
which is better for server/client connection. (Let's say the network is ...

is there a way to enable the remote connections without the need of
installing The SqlServer management studio?
I want to enable it on a SSEE but do not want to install the MS on
every server.

Not sure if this is the correct location for this post, but I'm very
desperate for an answer.
I dont know anything about SQL so this question could seem stupid.
The problem is I have a windows 2003 server running SQL 2000.  This as been

gfjghjg
From http://www.developmentnow.com/g/100_2003_9_8_0_0/sql-server-connect.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

I have SQL Server 2000 installed my system and have all the business objects. The database objects are accessed by two different business applications. My objective is to uninstall the set up from existing location (C drive) to a new location, say D drive.
My questions:
1) When I ...

i have 2 databases in diferente instances and i need to:
select my database in instanceA  and update the database in instanceB
also need to create a job for this script

I just installed SQL Server 2005 on my Vista (SP1) laptop.  I also
successfully installed SQL Server SP2 for Vista.  When going into SQL Server
Management Studio and connection to the default instance of the server that
was just installed, the following error is generated in the ...

this is an error that i recieve when i want to creat an sql database in c# environment at visual studio 2005:
an error has occured with establishing a connection to the server .when connecting to sql server 2005,this failure may be caused by the fact that under the default setting ...

I have a block of code that does the following:
1. Call Stored Procedure A which internally:
   a. Opens a transaction
   b. Does work

Hey all!
Hope someone can help? Not sure if I'm going nuts :)
I have two boxes both on the same domain. I am a domain admin and so have
full rights on both. One box is running SQL2005. Lets just call the other box

When I undock the computer from the port rep, I receive the following ODBC
error, even though it is a local database.
[Microsoft][ODBC SQL Server Driver][DBMSLPN] Connection Write (send()).
(10054)