Dear jezemine,

"ScriptingOptions" works.

Thanks a lot.

Dear all,

Microsoft said :

SQL Server 2005 Books Online (September 2007)

Script Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development...

Dear all,

Thanks for your replies.

I wrote a simple program with SMO, but why the result was different to the script which was generated manually :

using System;

using System.Collections.Generic;

using System.Collections.Specialized;

using System.Text;

using Microsoft.SqlServer.Management.Smo;

using...

Thanks a lot.