Is it possible to create a linked server to an Excel spreadsheet using a UNC?
I have no problems doing it with a file on the local server, but am having
trouble when using a UNC, which is what I really need to do.  If I use no
security context, I get an upspecified error.  If I ...

I was using the following command to update the data
source (a tab-delimited text file):
INSERT INTO table (COL1,COL2) VALUES ('AA','BB')
I found the updated text file looked like this:

After removing (an error) the default (window autentication) user from
(local) server i can access no more to it even with "sa" user.I have SQL
SERVER 2000 with service Pack 3 (sa without password). I would like recover
at least DTS i had on it...

Since installing the new SP2 for XP I have no longer been able to connect
using ODBC on a client machine to my SQLServer running on XP SP2.
I have configured SQL Server to use TCP ports 1433 and allowed this port to
be excluded in the firewall, but I still get SQL Server does not ...

In the Office we have a Win2000 Server running MS SQL Server 2000. I know
the servers external IP address (xxx.xxx.xxx.xxx) and we have a sub-domain
set up (subname.mycompserver.com). I have a login and password into the
server as well as the SQL login and password. The firewall ...

I have version 2000.81.9042.00 of SQLSRV32.DLL installed.  
Does anyone know where this particular version came from?
Hotfix? The MDAC component checker tool gives no useful
information.  I know that MDAC 2.8 will install version

I am using SQL Server 2k SP3 on Windows 2000 server.  I setup db maintenance
plans to backup my databases across the network to a Terrabyte NAS storage
unit.  The jobs execute, but then seem to lose connectivity to the NAS after
about 10 - 15 minutes.  I get the following errors in ...

We are setting up a backup server for one of our Web sites, and the current
machine is running Win 2K Server, the new one Win 2003 Server. Otherwise
everything else is the same.
Most everthing works fine, except for one ASP template, which is opening a

Friends,
I am new to SQL Server, and I access it mainly through
Access (ODBC DSN).
I need my queries to run faster, so I want to switch from

I have a .Net windows application that uses the micrsoft application block
to make calls to the database. I am doing a few thousand records that must
be inserted. I have a problem where on occasion I get an exception  that
says "SQL Server does not exist or access denied." This ...

Brand new W2K3 server in a workgroup, no domain. Server
name and IP address are pingable.
Installed SQL Server 2000 with SP3a, no errors. Chose
Windows authentication. SQL Server service and Agent

I tried to access Microsoft SQl database to get table list but i got the
followig error.
bf4.a30): Data misaligned - code 80000002 (first chance)
First chance exceptions are reported before any exception handling.

Hi, and Thanks for your thoughts!
I am evaluating a product, and the sales team presents an
option I am not familiar with.
Can a SQL/OBDC connection accross the internet be

I apologize in advance for posting this here and in the
ProjectServer NG, but I'm not sure which side the problem
is on.
I am experiencing a problem with getting users logged

Hi everyone, I need your expert advice. I have a w2k AD service with mssql on
it. and I setup another w2k server with IIS on it as webserver. my website
works on NT servers, but when I moved the website to the w2k server, it
doesn't work. It saids: