It's not a trick -- just testing whether or not people understand what the Developer Edition REALLY is... I guess I don't; I got it wrong

Agreed! At a place I recently worked (name withheld to protect the VERY guilty), management absolutely exuded the "you can be replaced" attitude. People were treated as objects,...

Just to clarify, there is no March CTP -- There is a February one and an April one

To get the query, try DBCC INPUTBUFFER(spid), where spid is the spid from sp_who2.

Try:

EXEC sp_who2 'active'

But if you already know what the two queries are, then why do you need to see the worst sessions?

Perhaps obvious question, but does the connection you're using have sufficient permissions to add a job?

Are these still available for MCPs somewhere?

If so, where?

Damn, leave it to Steve Kass (mathematician) to come up with a MUCH better solution than mine

There might be a cleaner way to do this -- I just kind of dashed it off -- and I apologize for the bad variable names, but I'm too lazy...

Sorry, I didn't understand the requirements before posting...

As someone else mentioned, dynamic SQL is the way to go in that case.

select CAST(CAST(0xF43C2 AS INT) AS VARCHAR(30))

?

Go buy a copy of Inside SQL Server 2000 by Kalen Delaney, and study, study, study.

I did. And so did two other people... Look at the forum topic:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=167917

What happened to that QOD review board?

Jamie,

You are correct. FINALLY is not available in T-SQL.