Jeff

It would be nice to re-design the database, but it was designed before I got here, and I cannot pitch to management that we need to re-design an existing application...

I agree.  

Too bad that both of my user groups need current data with little latency between both databases.   

EP

Looks like we are going to do the two server route.

On the brighter side, this will give me an excuse to play around with replication features and should give me a...

Good idea, but I already have the max degree of parallelism set to 3. 

But thanks, I didnt know about that option and will have to remember it for the...

Then again I think that there valid reasons for shrinking a database....

• The backups wont havet to walk empty pages
• the space can be used by other databases.....or even the transaction...

Well I was hoping that this was somthing that Microsoft had added. 

Especially considering that the MS code was originally based on the Sybase code line and the fact that Sybase has...

I looked at the affinity mask option, but I am not sure that it will do what I am looking for.   My environment is truly mixed workload.   The batch folks kick...

Thanks Ken, this is exactly what I was looking for

When you did the upgrade, was it an upgrade or did you install a new instance of SQLServer 2000 and still have the old one running on the same machine....

The easiest way is to put a few print statements into the trigger and then execute the stored prcedure in SQL Query Analyzer.

If you really know how far...