The post is now even older, but this command would easier to remember and place in code:

EXEC tempdb..sp_help #JBMTest

No need for dynamic SQL.

Oh, the beauty of system procedures!

🙂