I have a network with 6 machines sitting on it.
All PC`s are configued in the same way. 5 of the machines connect to a SQL
server via ODBC with no problems.
The sixth PC however does not connect to the server giving the following :-

We use SQL Server 2000 and have a Linked Server to a Progress 9.1E  
Database. Everything works fine until a schema change is made in the  
Progress database. We then get an error message similar to the following:
OLE DB provider 'MSDASQL' supplied inconsistent metadata.

I have a dedicated Windows 2003 Web Edition server running SQL Server 2000.  
SQL Server 2000 was pre-installed.  What tools can I use to interrogate and
update the SQL Server 2000 database from the Windows 2003 Web Edition Server?
Client and Adminstration tools are not supported ...

I am testing a asp page using sql server as the backend database. However, I
cannot connect to the database from asp. I have the following error coming
and I have also added the connection string that goes with the asp page.
Error Type:

I have tried to remote access my SQL server (from remote host to our
localserver)  but there is an error as below:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist

I have this problem:
When I create a new Login with a "SQL server authentication".
And if I change some User Mapping and Server Roles it gives me the follow
message "Create failed for User 'win2kadmin "

I have SQL Server 2000 installed which has a server name of NOTEBOOKDELL.
I installed SQL Server 2005 Community Technology Review last October, 2005,
and somehow gave it a server name of NOTEBOOKDELL\SQL2005 so that I can keep
my SQL Server 2005 databases separate.

Is there a way that i can rename some fields in a table using SQL from my
.NET program?  The customer send sthem in as BMT Number and I need
BMT_Number, etc.
Thanks

I need to rename a column in a table in a sql server database from my .NET
program.  I can't seem to find the syntax to do this.  Can it be done just
using sql?
Thanks

Connect to Sql Server

Connect using:
 [ ]  Window authentication

For some unknown reason we just lost the connection to our local SQL server.
The error message is "Connection failed, check sql server registration
properties".  I can't find any usable info on this cryptic error message.
Nothing was being done to the server around the time that ...

I am unable to connect to a SQL Server 2005 instance running remotely
on a Windows 2003 Server machine behind a router. I can connect to the
instance via SQL Server Management Studio Express when I place the
server machine in the DMZ, but I cannot connect when I forward traffic

The server I am working on is configured for TCP/IP, Windows
Authentication only, the SQLExpress named instance have been configured
to use port 1433 and the appropriate changes have been set on the
firewall .