I may have missed it, but is the database status accounted for anywhere in the final version of the procedure? I know that's something that I've run into multiple...

What is the 2 digit year cutoff in your server properties or sp_configure?

I did not notice that. You're right, using OBJECT_DEFINITION() would work. They also warn against using the ROUTINE_SCHEMA, but I'm just looking for some way to make my...

MSDN warns against using INFORMATION_SCHEMA.ROUTINES to query stored procedures since it only returns the first 4000 characters of the definition. They suggest using sys.sql_modules because the definition column there...

Are you using a fully qualified name (database.schema.object) when you're calling the procedure?

What the the default schema for the user and stored procedure?

How much detail do you want to get into for your trace? If you want to just look at table sizes you could run something like this

select OBJECT_NAME(object_id),...

but there's only one step, so won't that not do anything?