To humbleDBA,

You are right. INSERT ... EXEC works for table variable too in SQL Server 2005. In SQL 2000, it does not work. Thanks.

Jeff, Gail, and Chris,

Thanks for the workarounds for UDTs in master and msdb. I have not had a chance to test and confirm it.

David Quéméré,

Your are right. The script has a mistake. It's actually the workaround script. I guess I messed it up by copy/paste

Thank you guys for taking time to read/comment on it