fn_listextendedproperty is very particular about which arguments can be left out. Or rather it isn't particular, it just returns no output if it doesn't like your invocation.
The only 'wildcard' invocation I've managed to make work is
select * from fn_listextendedproperty('MS_Description', 'schema', 'dbo', 'table', 'thetable', 'column', default )
Putting default in anywhere else - even if the defaults are the final items in the list, as specified in the documentation - leads to no results.
Anti-nuisance lawsuit warning: The purpose of these notes is to remind me, Zoegond, of stuff or to help me work stuff out. They may contain mistakes.
Quick
- ($a, $b....) = unpack("A2A7...", $packed)
- push( array, list )
