What is the best way to import a large text like into a sql 2k tables. The
format of the file is like as followings,
Basically, I need to import into few tables based on the letter (A, B,C in
the filed).

I am accessing Sql Server using C#, System.Data.SqlClient.
Problem with DateTime. When the server is located in different part of
the world it uses different culture and display DateTime in different
format.

I spent countless hours last night and this AM trying to move the
mssqlsystemresource database in concert with that knowledgebase article for
which I wish I had an identifying number to give to you.  It's the article
that shows you how to move system databases.

I downloaded RC0 onto a Vista Business Dell Optiplex 755 (x86) quad
core. My directory listings for \x86 and \setup look like this:
C:\downloads\x86\setup>dir /b
1033

Does anyone knows what is the release date of SQL Server 2008?
Thank you,
Miguel

my script is
create table  #ravenJobs ( opportunityref varchar(100), txtcompany
varchar(100), txtRole varchar(100),
txtcandidate varchar(100), txtDeal varchar(100), txtLocation varchar(100))

1. How can I do running totals group wise efficiently and without using SP?
ID                            GROUP                 DATE
VALUE                  RUNNING TOTAL
               12323434             1                              1/4/07

I have the following tables:
tblQueue:
QueueID, CustomerID, ProductID, WeekIDFrom, WeekIDTo
tblSchema:

Ok, bear with with me here...
I have a big table (well, 500 rows) that has a list of debits,
credits, and "other". I'd like to write a SQL statement to retrieve
these, sorted in an odd way...

We are in the process of determining hardware required for a new application.
The expected SQL DB size will be ~70GB and the SSAS DB is etimated to grow
to ~35GB.  Are there some sizing tools/formulas that would help in
determining how much memory those services will need?  I've ...

How do you encrypt data in SQL 2005 so the DBA or SQL Server adminstratior
can't decrypt?  I don't see an easy way, but I found a blog that indicated it
may be possible.
thanks

A stored procedure which performs an insert from an MS Access table (itself
linked to a Pervasive database) and then performs a series of update queries
to sanitise the data runs fine when invoked from a query window.
In order to regularly run this stored procedure on a schedule, ...

We use sql2k, I need to import a 35 gb text file into SQL tserver.
The format of the text file is like as following,
"test51 ","012","0212        ",'231","2541      "," A          ","
","          ","210","5665   ","Testfile1        ","Frank T.         ","120

Client apps may be calling one of our stored procs from within a
client-initiated transaction. In case of error raised in the sp, I'd like to
log the error somewhere from within the CATCH block of the sp.
The problem is that because the error is reported back to the client, the

My goal:  I would like to create a base TIME DIMENSION table in MS SQL2005,
but I am very unfamiliar with how to CREATE such a table.  I need the table
to record EVERY CALENDAR DATE from Jan 1, 2004 to CURRENT DAY (with a way for
this table to hopefully update each day) as the ...