I am sort of new to SQL. I use MS-Access most of the time so I do not know
if you can do this, but...
In MS-Access there was a tool called documenter that would list out the
table def's such as fields, sizes, data types, etc. Is there such a thing in

A general data design question:
We have data which changes every week. We had considered seperating
historical records and current records into two different tables with
the same columns, but thought it might be simpler to have them all

Using "SELECT * " is a bad practice even
when using a VIEW instead of a table?
I have some stored procedures that are
identical with the difference of one statement

The following sql statement fails:
SELECT IdFlight, OrganizerLastName + ", " + OrganizerFirstName + "
Flt:" + FlightNumber As Concat FROM TableFlights Order By
OrganizerLastName, OrganizerFirstName

how can i replicate my customer_master to a table customer from a sql
statement.
I tried the following without success. Any one know the correct statement
CREATE TABLE customers AS SELECT * FROM custmoer_masters

I want to return a derived table along with 4 simple tables in a stored
procedure as follows:
Input parameter:       @FtNum     (==Order Number, selects one Order and all
associated data)

I have a vbscript to read all files from a directory and, if the file
is valid, I would like my DTS to process it.  I tried using the
vbscript as an ActiveX workflow script in the DTS, but it does not
execute the data pump until it has completed looping through all the

We currently have a production database on  SQL 2000 and have a separate 6.5
database running on a different machine, both on NT with the appropriate
service packs.  We have been reviewing the white papers to prepare for the
upgrade but are curious to know if there are any issues ...

I am using SQL 7 with an MS Access 2000 MDB front end, using bound forms
with ODBC linked tables. In one form, the user needs to be able to check a
box to select one or more records. This is accomplished with a local table
containing two fields: the primary key value of the SQL ...

After I've installed a new instance of SQL server 2000 standard, I will
apply the service pack. Do I need to re-apply the service pack to the
existing default installation as well?
Thanks,

In 2005 or less, are there any built-in routines to compress and decompress
"memo" type data?

Is there a function I can use in my view to cause a field to be displayed in
proper case (first char of each word upper case, rest lower)?

Why would a variable not  be recongized in a subquery?
I get this message -
Server: Msg 8155, Level 16, State 2, Line 5
No column was specified for column 1 of 'A'.

I was wondering if any body has used Internet as a WAN (Wide Area
Network) to provide database access. I know about web services but I
like to experiment with using Internet as a extended network (web
server behind one router and database behind another). Any ideas on

I have a report based on our product names that consists of two parts.
Both insert data into a temporary table.
1. A single grouped set of results based on all products
2. Multiple tables based on individual product names.