I haven't seen this mentioned anywhere, is this covered under the
"Update Performance" and/or "Updateable recordsets" headings?  Having
to include that in the connection string greatly reduced our
performance in previous attempts to use SQL Server from our Java

I trying to use sp_addlinkedserver, after I added successfully a new linked
server I do not know how to use the server...
I did this to add the server:
exec sp_addlinkedserver

Both are XP's (the one running Enterprise manager, and the one running SQL
2K) and the entire network only has a Workgroup (ANGELS)... thus
everything is machine local accounts.  Enterprise mgr complains that it
can't access the foreign SQL Server because it can't get rights...

Hi all, question for you please :
We have client app. running on the same server as SQL and using LPC as
a network library.
Very often we have the error message bellow and application just

We have an application that is connecting to our SQL 2k server remotely via
ODBC and sending a large number of individual insert statements. Apparently
this is causing problems with the transaction filling up on the sql database
the inserts are being sent to. To solve the problem ...

I have two servers in a network.
one of these servers are in a workgroup and the other is in a domain
when i run the following command in query analyzer of the domain server, i
get an error indicating device not ready etc.

This is the first MSFT sanctioned driver that has worked in our application.
I got it running in less than half an hour.

I have a java application which connects to an sqlServer database and issues
an SQL update statement.
When you attempt to connect to the database if there is no connection then
this is fine, it will retry for x times and timeout at the time you have

This may have been asked before, but I can't seem to find it.
I believe the default ODBC time out is 30 seconds.  I know that you can
override that by changing your application call.  Can it be overridden
without making program changes? Perhaps through a registry setting (though I ...

This is the first time I use SQL server for my application.
I need to set up 2 databases in the same server.
1. The first database need to be "hidden" hence no one else even SA should
not be able to see the database except for my application.

Sqlserver 2000/sp3a on Windows 2003
IIS 6.0 on Windows 2003 (seperate servers)
I'm getting application eventlog error 17055 (mssqlserver) entries and also
in the sqlserver log saying Login failed for user '(null)'. Reason: Not

After I installed ISA 2004 SP1 and Windows 2003 SP1, I have not been able to
make a connection to several SQL 2000 servers over VPN. I use Windows and
tried SQL logon. When I removed the servers from Available Servers in the
Register SQL Wizard, I see the servers duplicated. I've ...

Is there a where to Update the Value of a Field in one table to a Field
Value from another table.
The following works in MS Access but I am unsure on how to do the same in
SQL 2000