The Generate and Publish Scripts wizard supports a subset of the objects supported by the SQL Server Database Engine.
The following table lists the objects that can be published supported by the Generate and Publish Scripts Wizard.
|Application role||Database role||Schema||User-defined aggregate||View*|
|Assembly||DEFAULT constraint||Stored procedure*||User-defined data type||XML schema collection|
|CHECK constraint||Full-text catalog||Synonym||User-defined function|
|CLR (common language runtime) stored procedure*||Index||Table||User-defined table|
|CLR user-defined function||Rule||User**||User-defined type|
*Published without encryption.
**Any non-system users that exist in the database are published as Roles.