Use a Query to access column description in SQL

If by ‘description’ you mean ‘Description’ displayed in SQL Management Studio in design mode, here it is: select st.name [Table], sc.name [Column], sep.value [Description] from sys.tables st inner join sys.columns sc on st.object_id = sc.object_id left join sys.extended_properties sep on st.object_id = sep.major_id and sc.column_id = sep.minor_id and sep.name=”MS_Description” where st.name = @TableName and sc.name …

Read more

Enterprise Reporting Solutions [closed]

I’ve used Cognos Series 7, Cognos Series 8, Crystal Reports, Business Objects XI R2 WebIntelligence, Reporting Services 2000, Reporting Services 2005, and Reporting Services 2008. Here’s my feedback on what I’ve learned: Reporting Services 2008/2005/2000 PROS Cost: Cheapest enterprise business intelligence solution if you are using MS SQL Server as a back-end. You also have …

Read more