While there may not be a "query" per se, the idea you have of reading the sysjobschedules in real time is probably what happens. Perhaps there is some "backdoor" approach...

Rollback means it's rolling back. Likely something is stuck. Did you check for blocks?

If KILL doesn't do it, you'd have to do a restart to end the process.

Good idea. I'll add it to the list, not sure when we'll get to it.

You really need an external process that can accept the files and move them into SQL Server. It could run a DTS package, bulk import, simple insert, whatever.

As far as...

Profiler is the best way. Cumbersome and only for point use.

same here, email, not SQL.

, you need to send in the output parameter for it to be output. Otherwise where does the output parameter go? It's not a...

You guys are thinking too hard. It IS possible to attach back the mdf and get it working. It's certainly possible that this will not work, and there may be...

Haven't done much with it. Called in as a consultant to some companies that have used it but cannot restore. Worked with Veritas and sometimes successful.

My 2 cents: Not worth...

I'm searching back for the Q reference, but I actually ran into this one. I couldn't create a database and the reason linked back from PSS as Autoclose set on...

Like I said, it depends. They don't need any of those roles necessarily. If I want someone to run imports via DTS from Excel, I can add him as a...

depends on how they do it. Could get by with insert and select (maybe update). Sys admin isn't something I'd give out.

It can take awhile if it's lots of GB of space. Glad it's fixed for you.

replication may be the answer.

I don't think so, but you may email or check Ken Henderson's book.