Hi,

You probably need to give a bit more info to get an answer.

Are you look for an ADO connection string?

Are you in SQL Query Analyser and are trying to connect?

Are...

In my opinion, you got a bit wordy which meant your proof for your ideas was less clear.

Other than that, I agree with what you said.  I believe most of...

I'm a "do it all" developer on a system which is one system which accesses a reasonably big (160 GB) DB, but I have read a fair bit on this site...

 "SELECT @NewDefID = max(defect_id) FROM DEFECTS

 SET @NewDefID = @NewDefID + 1 "

As and aside, you could set defect_id as an IDENTITY field with a Seed of 1 (the default) .

This will...

If some of your data is relatively static you could update a database once a day/hour/week with your aggregate values and set it as read only and pick up you...

Sorry! SQA is ISQLW.EXE - the "SQL Query Analyser".

100% sure that the records are not being deleted.

3 users and we only need to select for what we are doing.

By the...

I don't usually comment on something that is not finished, but surely for someone with the right permissions being able to do "point 2" is quite useful.

Obviously you would not...

In the same book their is a very detailed bank account reconcilation system which you'll be able to borrow loads of good ideas.  One of which is...

Table Columns in "Transaction"...

I am reading "Pro SQL Server 2000 Database Design: Building Quality OLTP Databases" by Louis Davidson published by Apress (http://www.apress.com).

The ISBN is 1-59059-302-2.  Check the Apress site as there...