-- get stored procedure name , it's ext prop name and value
SELECT sp.name , ep.name , ep.value from sys.extended_properties as ep inner join sys.procedures as sp on ep.major_id = sp.object_id
--get ext props name value for tables
SELECT sp.name , ep.name , ep.value from sys.extended_properties as ep inner join sys.tables as sp on ep.major_id = sp.object_id
Posts
What the heck is a `\\.\nul` path and why is it breaking my Directory Files
Lookup?
-
[image: Null Device Banner]
In the last few months my Markdown Monster Application Insights log has
been inundated with a hard failure for lookups of a \...
3 weeks ago
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!