Property data updating description
As I previously mentioned, the purpose of this tip is not to show specific tools, but that those tools use the Extended Properties to manage the Data Dictionary.To take this a step further, there are other tools to generate SQL Server Documentation which generate the reports based on Extended Properties as well.There is a great article SQL Server Data Dictionary in Seconds using Extended Properties that you can read to understand how you can use Extended Properties and also you can check out Books Online for this article - Using Extended Properties on Database Objects.Like I stated previously, when you are working with an Enterprise Data Modeling, very often you are going to use third party tools to manage the model.You can map each of these crawled properties to the Author managed property so that when a user queries by author, appropriate results from the three document types are included.
There might be some changes with SQL Server 2011, but I am sure there will be an easy work around if they are not fully supported.
In this article: Adding a managed property Editing a managed property Deleting a managed property Mapping a crawled property Changes to the property mappings take effect on a document-by-document basis as soon as a document is crawled, regardless of the type of the crawl.
A full crawl ensures that the changes are consistently applied to the entire index.
So what options are available to manage and build the data model? Fortunately, most major data modeling tools that I have worked with so far use the same methods to store the Data Dictionary.
Some tools may use different terminology and may have more features, but essentially the underlying technologies are the same.
After deploying a report in Sql Server Reporting Services 2008, one discovers that the Report Server has the ability to display an informative Report Description next to each report.