Here's a problem that I can't fix. I have an application that uses a SQL
database. The connection is made through ODBC. Also this application uses the
same username for all the connections; yes it's one of those.
Now this application generates a blocking in witch one spid is in ...

I have a SQL 2000/2005 server (2005 is a named instance, 2000 is the default)
which I can no longer connect to from remote machines using Management Studio
(or any app that uses the Native Client).
Further, I can connect to the 2000 instance using Enterprise Manager or

in sql server 2000 when you issue a alter table to add new column, can you
specifiy the order? meaning i want that column to be between existing
columns, not at the last

I have a scheduled task that runs a batch file in windows 2003 server which
is running SQL Server 2000 Enterprise.
The batch file contains the line:
OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log

I have placed a Windows 2003 server, running SQL Server 2000 on a DMZ that is
on my internal network.  I understand that as a Windows system starts, it
advertises its services through Service Advertising Protocol, which allows
client computers to browse and select servers of a ...

my environment is SQL 2000 SP4 on WIN2003 Server Standard.
In enterprise manager, when I have to create a new sql registration, on a
server I can see (local) instance, on the other one NO !!
Server are the same, (HP Proliant DL380)  , please could anyone of you give

The new SQL Server 2005 JDBC driver 1.0 release is giving me some headache.
Due to some indexing problem, we used the setAsciiStream() method in
PreparedStatement class instead of the setString() method to populate a
VARCHAR field with Java String object (Some guy in my team told ...

I have tried to create my procedure by cut and paste the sample FTP get file
using tsql from Author Nigel Rivett (
http://www.nigelrivett.net/FTP/s_ftp_GetFile.html).
When I tried to execute it by passing parameter as below:

Well like everyone else, I see folks moving to simple recovery mode for their
SQL databases and making more daily "full" dB backups.
So now that I have moved from full to simple recovery mode. I still have all
these transaction files killing me in space. Like 77GB!

I am having a problem exporting a linked SQL server table from Access 2003
to
Excel.  The file is about 2,000 records with several columns.  The problem
is that when the table is imported into excel some of the records are not

We have a 33GB database on Windows 2003 RC2, SQL Server 2005 SP1 on HP585
AMD64 bit with 4 CPUs, 16GB RAM and 3 disks on storage array.
Our five web server connects to database and queries database.
The problem is when we make a request on a web server, it generates a query

I used SQL Server Enterprise Managers' Export Wizard with destination ODBC
driver for SQL to create a dts package in the structured file format.
I entered the following dtsrun line (msde 2000 sp3)
       dtsrun /S servSQL /U sa /P thepw /N db.dts

After installing Visual Studio 2005, SQL Express and other stuff I no longer
can select my ODBC DSN name within MS Access 2003.  When I link to a table in
MS Access 2003 I should be able to change the File Type to ODBC from the
standard file open dialog box and a new dialog box ...

Hi, I've a Access 2003 program with linked tables to a sqlexpress configured
with mixed mode security.
From clients XP no problem.
From clients 2000 MSACCESS don't get the right configuration from ODBC

do you know the connection string for accessing a sybase DB from a Windows
environment (more effective than odbc)?
thx