We're getting error messages on XP Pro clients connecting to an SQL 2000+SP3a
server running Windows Ent. Ed.+SP1.  The clients have SP2 installed which
includes MDAC 2.81.  The error messages come up in the following sequence:
SQL Error: 01000 (10054):[Microsoft][ODBC SQL Server ...

I have installed a msde 2000 on the server with windows authentication. Does
this mean that anyone that has access to any of the computers connected to
the server has a way to getting into the database?
I am using access mdb front-end for data entry and linking via odbc using

I am doing a new installation on new clustered hardware.  The database and
transaction log files will reside on an extenal RAID.  Is it better to keep
the two files in the same partition or on different partitions?

Here is my situation;
I have two tables in a MS-SQL DB. One table with dollar amounts and service
codes. I have a second table that I want to move some information into from
the first table. The catch is I want to move one field as is from the first

I have a text file with this information
-BEGIN----------------- tekst.txt-------------
10, "firstname", "lastname"
11, "Mette", "Larsen"

Hi guru,
I've been new company for only a month and started analysing Index
Fragmentation.
After I ran DBCC DBREINDEX and capture data into permanent table, I 've

I am trying to update a temporary table with data from another table.   The
problem is that the field which is common between the two has a many to many
relationship to the field I am trying to update.  Therefore when I run the
update I am getting the first record returned to my ...

Hi, I have the query below, the problem is that it returns duplicate results
(with same a.id's)
I need to add a 'distinct' clause so that I don't get repeated results for
the a.id

I want create stand alone application from DTS package. I remember I
did one time ago, I couldnt recall how I did it.
Thanks.

Could anyone please help me out as to how we can save the excel workbook in
the database and
read it back.
I was able to convert the text files and image files into binary format and

I am trying to use the 'Bulk Insert' command to load a data file into a
MS-SQL db. The line I am using is:
Bulk Insert SVC_Details From "C:\XFILE.TXT" With (FieldTerminator = ',')
I have tried the file name with " around it and with ' around it and both

My actual table has more columns and entries...Iam trying to eliminate the
empty cells. Column 1 and 2 need to maintain their relation to each other and
3 and 4 need to maintain their relationship to each other
Table 1:

I have a recordset that I need to paste into Excel.  But depending on
the criteria, this recordset could be larger than 2 sheets, sometimes
3.  So, I need to be able to devide this record set up evenly.
What I've done is  created a view that counts the number of records in

Dear group,
is it possible in SQL-Server to see when a stored procedure was
executed ?
I would say it is only possible with some traces but not with the

I am trying to execute a BULK INSERT ... this is my code
BULK INSERT  myTableSQL.dbo.[Daily_ss] FROM 'c:\daily_ss.txt'
WITH (
    DATAFILETYPE='native',