DESCRIPTION: This script will not create the extended properties, but auto generate the commands to do so. The actual value (@value parameter) of the extended property still has to be manually input.

With SQL Server 2008, the Generate Script functionality in SSMS allows us to script the data out of a table into a batch of INSERT statements. Let's walk through this in detail.

'Failed to generate the database creation script from the report server using WMI. Errorcode: -2147023181' If the current behavior is a bug, please provide the steps to reproduce and if possible a ...