http://www.sqlservercentral.com/columnists/sjones/killthattarget.asp

The NET commands can help with the last part

-------------------------------------

C:\Documents and Settings\Administrator>net start sqlserveragent

The requested service has already been started.

More help is available by typing NET HELPMSG 2182.

-------------------------------------

As far as...

How are users of Active Directory sending email?

Correct. In the SQL 2000 case, there are 2 CDs. One is the version you purchased and the other is Personal, which is free for all CAL authorized users you...

nothing for multiple columns.

Did you perform a RAID backup to multiple files?

If so, then you might need to call PSS.

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 $$.