All,
I'm designing a database that tracks user attendance. There are a lot of
descriptions that could apply, e.g. tardy, late, early out, excused absence,
undocumented absence, etc and some of them can be combined.

I have a query that will filter out results using a start date and an end
date. I want that if the user does not enter a start or end date to use
defaults so that they get to see all results.
What would be the minimum date and maximum date that I can enter as defaults

I have two tables of data, table1 and table2. In Table1, there is a
"id" field, a "name" field, and an e-mail field. In table2, there is an
"id" field, and paramters that belong to the certain "id". When I want
to create a new record, I want to make both of the entries at the same

I need a book, website, anything to get up to speed ASAP on Data
Transformation Services and programming in VB Script.
We are running SQL Server Enterprise Manager Version 8.00.194.
Any help and guidance would be GREATLY appreciated!

I am trying to add a column to a temp table and then immeditaely query
against that new column. If I do this in Query Analyzer it works fine
as long as there is a go in between, but I can't use a go inside a
stored proc.. How do i get SQL to finish processing the alter table

Kalpesh Thaker; Dirty Plagiarizer
http://www.sqlservercentral.com/columnists/sjones/apologiestokenhenderson.asp

I have over three hundred text files that I need to import to SQL
Server.
Each is in the exact same format.
I want to import tham as seperate tables.

Can anyone put a name to the following type of design...
I need to be able to modify the amount/names of data "fields" stored
for an entity so instead of representing the data stored for an entity
in fields associated with that entity you would relate it to an another

Dear members,
I'am thinking about the "best" way to connect to my sql-server via
ADO.Net (if there is a best way).
My application uses the sql-server very intensively. At the moment

I know that there are tools like Lumigent, but an wondering about the
internal facilities to track events such as table creation, security
operations (add login, add role), and such.
Under Sybase, there is a set of procedures that permit you to set

I assume a SS# or Phone# should be either a varchar or char field. But
is it a good idea to store a phone# or SS# w/ seperator characters or
without them?
Phone# "(123)-456-7890"  or "1234567890"

I have 1 developement Database and 3 databases for 3 different countries.
They are all located at the same server.
I have the same tables and the same roles in each database. I want to make a
script, which can copy role permissions from the development db to all the

I have been searching for a published document for Best Practices
concerning access levels based on roles.  Should developers have more
than (if at all) select level access to production data?  If I
understand (from multiple postings) that it is best to have:

Someone asked me a curious question.
Can I execute a query to sql server from a bat file?  how?
If not is there a simple scripting laguage that this person might use to
drive his process that is similar to a dos bat file?

I have not been able to find any details about backup failures for
MSSQL 2000. I am researching the following:
1. when a backup fails at a certain point during the process does the
backup: