Brill. Thanks Chris.

I might ask MS if they can include this in sp_helptrigger

Interesting to note Steve's opinion that a senior SQL DBA should be on 90000USD.

XE.com tells me that, at today's prices, that is 49182GBP. Based on what I know about the...

The only way to create SSIS (SQL Server Integration Services - the replacement for DTS) packages from SQL Server management Studio (SSMS) is to use the import/export wizard which builds...

I can't see the screenshot. Can anyone else?

Hey Frank, no wonder you've had time to post 5098 times. You're never at work

Blimey. Like I say, I'm shocked.

I get 23 days per year (3 of which I have to take between christmas and new year). This rises to 24 after 4 years....

Set the excel source up as a linked server.

What really grabbed my attention in what Steve said is the following:

"My friend would seem to have a great place to work. Two weeks vacation off the bat, 3 after...

John,

Got any links to some such threads? I'm all intrigued now (god I hope one of them isn't mine

"Dear SSC, This SELECT thingummy...what's...

The explanation of the answer is still wrong by the way (or it was on this morning's newsletter anyway).

Fantastic, I figured there'd be a way to do this. Thanks Linda.

As far as I know (I stand to be corrected) this is wrong. FINALLY is not available in T-SQL.

Kenneth,

I always do - hence this is an exception proving my rule.

On this odd occasion it made sense to do it in EM...

That's fine Lloyd. I'm fine with writing SQL or using constraints, I'm just lazy that's all.

By the way, TIA is an acronymn, not my name! 

Sure.

http://www.panorama.com/pdf/030705_4-5_BETA_FINAL.pdf