I have two SQL Server installed on a Server.  One is using default port 1433,
the other is using another port 1400.  Due to virus infected, may I block the
port 1434 and setting the alias for the non-default port 1400 at the SQL
clients?  Will there be any other impact ? Thx

Using Microsoft SQL OLE DB to create the linked server, whether using
Enterprise Manager or Analyzer script.... The linked server appears to be
created successfully, and I can see the database tables, but I cannot see any
of the data in the tables.

Is there anyway of connecting to a remote SQL Server other than via a
VPN.
The remote SQL Server has a connection to the internet via a firewall
which has a static public IP Address.

for the past few days, SQL Server 2000 ( 8.0.0.936 ) has been using aup all
the threads in the database.   During the night when web traffic slows it
releases some but not all of the threads.  
What causes SQL to keep grabbing threads at an alamring rate, then never

I am hoping this is the right place to post...
I am trying to find out some information on .NET over wireless.  Currently I
have an application that makes sql querries to a sql database.  The
application works fine over a wired connection, how ever when taking the

We have a web service that accesses an SQLServer database. The database has
hundreds of thousands of rows.
We open a cursor in order to allow the user to page through output, but
processing takes too long and the cursor consumes too much memory.

Good day
In my application ADO Connection’s Open() method is used to open connection
to SQL Server. Using profiler I see the following for Audit Login event:
-- network protocol: TCP/IP

Can JDBC driver connect to Linux

I have tried everything..I cant get Java to connect to my sql
server...
heres the code I altered provided my microsoft to test this connection:
import java.sql.*;

I have an ASP app I am trying to implement which is giving me some weird
results.
The environment is a Windows 2003 Domain.  The IIS Server is Windows 2000
SP4, SQL 2000 is running on a Windows 2003 server.

I am using SQL Server 2000 on Windows 2000 server. Here is my problem:
@String = 'word1word2word3word4word5' - This value is passed to Stored
Procedure from the script.
Column1 in a table1 has many rows with "words" . One row in this column1

While we update our datawarehouse we don't want the users
to be able to connect to the database and update
their reports.
So we want to block access during certain hours.

Experts Please reply
I am developing MDI parent with multiple child forms. All the child form
would have only database records. So I need SQL Connection to connect the SQL
Server 2000. Which is the best procedure to connect the database. Either

We have our SQL Server 2000 Ent. Ed. SP3 set up to use Windows
authentication from a Windows Server 2003 domain controller running Active
Directory in Windows 2000 compatibility mode.  From the office, everything
is hunky-dory.  However, we have many employees that need to ...

I was able to create a linked Oracle server using the SQL
server Enterprise Manager.  When I creat a query I am able
to view the the data that was selected however I when I go
to save I receive the following error message: "ODBC error: