Philip,

What you need is a good document managements system plus the internal procedures in place to use it.

Ideally the documents need version control so I would say have an official...

Yep, agree with all this but I would add documentation to the list.

The situation I am in is where the stored procedures are effectively an interface to the database layer....

If there is a new configuration change then the main thing is to test it away from potentially embarassing situations.

We got stung in the jump from 2.5 to 2.6 because...

I like the idea behind WITH UPDATEEXISTING.

I feel it needs three settings.

• ON - Does what it says on the tin.
• OFF - Performs INSERTS only but throws errors if ...

How are you going to cater for Rob, Bob, Robert, Robin, Bert. They could all be the same person or they could be all different.

Speaking as someone who has...

Try this instead

CREATE Procedure p_get_customerdetails

/* Param List */

@Customer_ID int,

@view Int =0 AS

Set NOCOUNT ON

/*

    0 = CustMain

    1 = Devices

    2 = Setup

    3 = trxHist

*/

IF @view = 0

    BEGIN

        SELECT * FROM vw_CUSTOMER...

Visual Studio has a tool called "Application Performance Explorer". I have to admit that I've never used it, but it is there.

I've heard of a tool called SQL HAMMER,...

Hans,

If you use Full Text Search facilities then you must have a primary key because SQL Server saves various status flags and other bits and bobs in the primary key.

I...

quote:

---

Can I host all the SQL Servers on one powerful machine under windows 2000?

---

Yes...

quote:

---

I don't understand your point? Why do you so forcefully express that your Identity column HAVE to be your primary key?