Creating the temp table makes sense to me. Depending on the type of process, you might want to then add it to some type of history table anyway.

Andy

Im not sure what you're doing there. I created the proc and ran, got a message in QA that some results were being dropped because resources were low - no...

I have not seen this. But I dont use the feature that often, usually just when I need printed copy of the schema for a few tables to reference while...

Maybe pause the server? Not sure what result you need. Typically you'd just set a command/connection time out on your client app, then trap for the error if it does...

I dont think I'd put this in a trigger, depending on how good your UI is (and the # of times people access the table directly) you may wind up...

Try it on the server itself to see if you have the same issue. I've had problems with counters disappearing that was fixed by putting the same service packs on...

I'd recommend against using a server cursor for writing out to asp. A better solution is to pull the data into an ADO recordset (even if you have to go...

EM is probably using DMO to get its numbers. Maybe try profiliing EM to see what is getting sent to the server, if anything.

Andy

Take a look at BOL - there is a hint called FIRE_TRIGGERS you have to use with Bulk Insert or BCP.

Andy

The upsize wizard is a good start. After that its worth spending some time looking at how triggers and stored procedures can help you. Certainly you can program against Access...

I've seen variations of this - usually something weird happens when SQL first starts where it cant find the port. Restarting the service has fixed it the couple times I've...

Its definitely necessary sometimes to dig into this stuff, but it only matters when you're tight on resources. I learned this the hard way - just buy a bigger dog!...

Nothing wrong with battery backed cache. Although tuning it is a royal pain. You've got the cache caching, SQL caching - you spend a lot of time trying to start...

One kinda cool way to do is by using the web export wizard.

Andy

Couple other ideas. One is to just change them one at a time, see what breaks. Some might be outdated/not used anyway. You could try using Netmon to capture the...