Thanks for the suggestions

Yes, MSDTC service is running.

I've tried toggling both SQL Login and NT authentication.

I think my next step is to tear it down and start over. Perhaps...

One angle of 100% uptime that was not considered, is replicating your database accross sites. This way if a site takes an outage (power, disaster, etc.) your replicated database...

Another solution would be to make the 'set' part of your connection prior to doing the insert, or just before the insert do the set. However, I think Steve...

I use Embarcadero's RapidSQL for this. The SQL extract has an option to put each procedure into one large file or individual files.

The DDL extract has proven to be...

Bad news....got another 823 last night.

Steve - thanks for the links to the two MS articles. I do not believe I am hitting either of them. ...

SQL Server 7.0 Service Pack 2 running on windows 2000.

Five databases. Four databases under 500 MB. The database with the 823 is just under 4 GB.

Steve - Good suggestion on the permanent table suggestion.

We have been kicking that idea around.

The permanent tables would get populated using update/insert triggers and then the reports could...

Dough! That was way too obvious - Enterprise Manager. Thanks for answering that one.

ONE GOTCHA that I ran into that applies to all SQL Server upgrades, etc. ...

Thanks for the information. I agree that less tempdb would be beneficial, however, the schema that has been dealt to us does not lend itself to good / performance...

DavidB -

Pardon my ignorance, but what is "EM on the Client machines to SQL Server 2000"?

Thanks for your earlier reply.

Cheers.

In our shop we put the onus of this task on the development team. The changes they make must have a 'conversion' script with it that will take a...

You can create dynamic SQL within you stored procedure. You would not get the benefit of compiled SQL but you would have the benefit of all your database code...

Steve - ever find anything out about this?

I have not had any luck.

We improved our performance by adding RAM, but I'd still be interested if you ever figured anything out.

Cheers.

-...

The way I have been measuring the *performance* of the systems is the number of documents per hour that our system can process. A "document" is an image with...

Greg - Could you post more details? Queries/reports that run for hours might be restructured to run in less time.

Also, I have found that adding 'with recompile' to stored...