We had an external networking company setup the machine for us. I didn't do my due diligence and assumed it was a RAID using several discs (can't really blame...

I suspect it is the hard drive; therefore, I've run some IO tests just on the drive itself and the write times on the disc are incredibly slow. I'm...

Put this in wrong forum, but not sure how to move it!?

Why keep a do nothing trigger in the database?

Interesting how opinions can be made without knowing the business rules and logic of the triggers, users, etc.

Here is the solution I developed with everyones recommendations.

1) The Disable works great (slight format change - I'm not sure if it is because I'm using SQL 2000). ...

I could separately the install scripts, but future requirements dictate I'll have to do many similar items and the tracking becomes quite cumbersome. Your first idea sounds quite plausible...

The trouble is that it always wants the CREATE Trigger statement immediately after a GO statement. I'm not sure how I could do a conditional check and then run...

I'm not exactly calling it 400 times in a row, but I may call it 400 times during a processing routine. We are processing tax returns (a very specialized...

I am using Access 2003 and ODBC to link with the tables and am now having numerous table locking issues.

A big problem is when creating reports. ...

It seemed like several sites talked about gaining stored proc efficiences through the use of a persistent connection to the database. Is this true?

I've also been looking into the...

Have you figured out a methodology to determine the order in which the views should be refreshed?

I have a similar problem, but it relates to both refreshing and...

Thanks for the help (sorry about the late response). I'm testing out the above information today. As per the creation order, it really is not important. I...

"select * into #td from deleted"

In the trigger, the data is copied into the mirror table. I've done similar, but cannot use the generic statement with timestamps (and have...

Oops - I'm not sorry for all the responses, I'm sorry for my own late responses!

Sorry for all the responses - I've been on vacation and never turned on a computer. Perfect!

Per Jo Pattyn: I use stored procedures whenever possible. The problem...