• Mike,

    never knew you could pass parameters into those shortcut macros!!!

    BTW - have tried it on my version of SQL2005 Management Studio and it works OK.

    I was thinking of using it to output the procedure text from sp_helptext when I had highlighted a proc name, but I'm having issues with scope - if I create the proc in Master it tries to look for the highlighted proc in master.

    I'll get there.........