SQL Server Forums - What's wrong with my SMO C# tiny program?

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

What's wrong with my SMO C# tiny program?

New Topic

Author

Topic

m.i.d.
Starting Member

2 Posts

Posted - 08/14/2012 : 12:06:30

I want to script SQL Server objects programmatically [say, delete (DROP) all FKs, then change keys, and restore (CREATE) FKs] with SMO Scripter class.

I found [url=http://www.yaldex.com/sql_server/progsqlsvr-CHP-12-SECT-1.html]an article on the Web[/url], but...
Please see [url=https://dl.dropbox.com/u/60064807/SMOQuestion.jpg]the image[/url] and help me to compile ~20 line long C# program.
Thanks.
I am not a rookie. No.

sunitabeck
Flowing Fount of Yak Knowledge

5152 Posts

Posted - 08/14/2012 : 13:28:08

Add a

using Microsoft.SqlServer.Management.Sdk.Sfc;

or use

scripter.Script(new Microsoft.SqlServer.Management.Sdk.Sfc.Urn[] { db.Urn });

m.i.d.
Starting Member

2 Posts

Posted - 08/15/2012 : 08:51:54

Thanks, sunitadeck. It works. Something seems to change since SQL Server 2005.
Case closed.

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.03 seconds.