Run query analyzer (isqlw.exe) and load the script (File Open, cut and paste, whatever) and then there is a green arrow to execute it. You can also press CTRL-E or...

Are the values in a table? There is a max() function. Look under aggregates in BOL.

I don't believe you can do this. Many of the calls made by EM are not supported in v6.5

That's true, in places MSDE and Express will probably make good systems, more like embedded systems. I still think of production as a system used by multiple people. Too often...

dbcc inputbuffer ( 13) with tableresults

Did your log grow last night? The latches are a precursor to locks and when the log grows, everything pauses. This could result in some timeout type problems.

I'm thinking that you could audit these in SQL 7, not sure. But if you can, then it's in the SQL Server log. You'd have to have turned this on,...

Apologies!

My fault. Mark asked me to link it in and I forgot . It's up there now.

Microsoft has a few in the resource kit for SQL 2000, but almost all I've seen cost $$.

SQL is very intolerant of any network delays as well. That's not your error here, but I'd recommend a local drive as well.

Drop them

Why would you want to? Updte them, I mean. They are not "rebuilt" on updates.

And here:

http://www.sqlservercentral.com/rc

You're having network issues. The backup routine is very intolerant of any network latency. Backup to the local drive and the move it to the shared drive.

Brian Knight has some articles on clustering on this site. As far as load balancing, I'm assuming you're active/active and you are looking to move some dbs to each server...

I hate applications like this. , my buddy builds an accounting app like this and I always complain about this crap. He says they...