Ok, after putting up my first post on the Data Dictionary I had posters remorse. There is a simple change that makes the script shown in the previous post a little more user friendly. First the view metadata.columnsDataDictionary need to be changed from
Having a data dictionary is an invaluable resource for not only for the DBA but for anyone, report writers or developers who need to work on a database that you have to manage or have developed yourself. A good amount of time can be saved from answering
Friday, January 04, 2008 10:18 AM
Output Clause
Alright have to give credit for this post to Andy because he is the one who pointed out how useful the Output Clause on an insert statement could be. Starting in SQL Server 2005 you could add an output clause to an insert, delete, or update statement