Hi,

follow you can find a patch about template file (SqlServerScriptTemplate.tt)

#line 41 "D:\Sculpture 3.0\SExpert\Source\Molds\DatabaseMold\Templates\SqlServerScriptTemplate.tt"

        foreach (IColumn column in element.Columns)

        {

            if(false == string.IsNullOrEmpty(column.Description))

            {

           

            #line default

            #line hidden

            this.Write("-- Create Column \'");

           

            #line 47 "D:\Sculpture 3.0\SExpert\Source\Molds\DatabaseMold\Templates\SqlServerScriptTemplate.tt"

            this.Write(this.ToStringHelper.ToStringWithCulture(column.Name));

           

            #line default

            #line hidden

            this.Write("\' Description\r\n");

           

            #line 48 "D:\Sculpture 3.0\SExpert\Source\Molds\DatabaseMold\Templates\SqlServerScriptTemplate.tt"

            this.Write(this.ToStringHelper.ToStringWithCulture(string.Format(

                CreateScriptResources.AddDescription,

                column.Description.Replace("'","''") , //OLD => column.Description,

                element.SchemaName,

                element.Name,

                column.Name)));

           

            #line default

            #line hidden

            this.Write("\r\n                \r\n");

           

            #line 55 "D:\Sculpture 3.0\SExpert\Source\Molds\DatabaseMold\Templates\SqlServerScriptTemplate.tt"

                

                    }

        }





Regards

Because i you don't replace this character the script generated would be:

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'i'll be go?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_TEST', @level2type=N'COLUMN',@level2name=N'Type'

while sould be

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'i''ll be go?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_TEST', @level2type=N'COLUMN',@level2name=N'Type'

Regards



-------------------------------------------------------------------------------------------------

for example this's right:

CREATE TABLE [dbo].[TB_TEST](

 [Type] [nchar](3) NOT NULL,

 [Name] [nvarchar](30) NULL,

 [Id] [int] IDENTITY(1,1) NOT NULL

) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'i''ll be go?' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_TEST', @level2type=N'COLUMN',@level2name=N'Type'

GO