>Oh, I thought he might be trying to get it to work like an Automatic variable. like @@Rowcount. The only reason I say it, is because I once wished I could create some constants globally to just access as needed in any procedure. Is there a way to do it.

Kind of. Take a look at the topic Session Context Information in the BOL.

-Mike