How to know the name of the SP that is executed

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 1

SELECT OBJECT_NAME(@@PROCID)

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 2

SSChampion

Points: 10207

October 14, 2008 at 3:09 am

dbcc inputbuffer(spid)

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 3

SSCrazy Eights

Points: 8147

October 14, 2008 at 3:13 am

you can find with sp_who2, try it once.

carlos.tapadinhas Ten Centuries Points: 1058 More actions · Answer 4

Ten Centuries

Points: 1058

October 14, 2008 at 3:13 am

Thanks Mark for u quick answer, help me a lot