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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2005-07-05 : 06:11:50
|
| Is there a system sproc or function that returns all the descriptions you entered for fields and tables of a database? I know you can change the custom settings when creating a diagram, but is there any other more immediate method (i.e. query the system table that contains the info???).Thanks in advance!Hearty head pats |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-07-05 : 06:18:52
|
| Perfect! Just what I wanted! Thank you very much!Hearty head pats |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-07-05 : 06:28:10
|
| I don't suppose you could elaborate on the second option. I get the first, but I don't really know what is going on in the second?? For example, what is it querying - ::fn_listextendedproperty ???Thanks again!Hearty head pats |
|
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-07-05 : 06:30:04
|
| Sorry, me again! I did what I shoudl have done in the first place and looked it up in BOL! So I now have a clearer understanding! ThanksHearty head pats |
|
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-07-06 : 05:01:23
|
| I have discovered another problem. The database data and schema is scheduled to be dropped every night (using DTS) and rebuilt for automated testing purposes. The DTS package is simply 2 tasks, the first dropping and recreating the database and the second for re-populating the database with the same test data. I generate the SQL script using Enterprise Manager, but the script does not include the descriptions of the tables and fields. How can I overcome this?Hearty head pats |
|
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-07-06 : 06:03:08
|
| Just been thinking....is there a method of writing the descriptions in SQL Script as opposed to using the Enterprise Manager? Or would I have to simply locate the system tables and do an insert?? Hearty head pats |
|
|
|
|
|
|
Retrieving comments and descriptions