I am currently using this store proc to get columns information : SP_MsHelpColumns because with this one I get the COL_LEN and COL_SCALE.
I cannot have this information from INFORMATION_SCHEMA.Columns nor SP_Columns
And I use fn_listextendedproperty to retreive extended properties.
Is there a way to combine the SP_MsHelpColumns with the fn_listextendedproperty in one single SQL statement?
Or What's the SQL statement behind SP_MsHelpColumns?
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)