Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ProEdge
Yak Posting Veteran
64 Posts |
 Posted - 2007-03-15 : 19:34:36
|
| I have a question about using SQL Server's built-in function to retrieve extended properties information, fn_listextendedproperty. According to BOL, you can use either of the two queries below to list all extended properties for the database it is run in.SELECT *FROM ::fn_listextendedproperty(NULL, NULL, NULL, NULL, NULL, NULL, NULL)-Or-SELECT *FROM ::fn_listextendedproperty(default, default, default, default, default, default, default)However, it has never seemed to work for me. I am able to retrieve them when I provide the appropriate parameters such as table and column names but this option that BOL specifies does not work. Does anyone know why or of a why to list all extended properties? Thanks |
|
|
ProEdge
Yak Posting Veteran
64 Posts |
Posted - 2007-03-16 : 11:57:52
|
Anybody? Lol  |
 |
|
|
ProEdge
Yak Posting Veteran
64 Posts |
Posted - 2007-03-23 : 14:22:34
|
| *bump* Sorry but I'm still curious about this. I can't seem to find a solution to this anywhere on the net. |
|
|
|
|
|
|
|
|
Extended Properties