I don't think your assumption is correct...SMO is a replacement for the old DMO COM objects from SQL Server 2000.  WMI still exists in whatever form it is.  I'm not...

I am/was in a similar situation, transferring data from Oracle and I needed to use the Script Component. The official documentation is sparse. Here are some tips:

- After you add...

Just an update to my post...

I've been working with some knowledgable people and I haven't been able to find a resolution to my problem.  Two things that may be causing...

Just an FYI to anyoine out there...I installed VS .NET 2005 beta and the SQL SMO namespace worked fine.

Jeff

Fantastic, that worked!  Thank you.

Thanks for the link.  Very interesting, from what I can determine, there still is an 8k limit in SQL Server 2005 but it doesn't apply to VARCHAR columns.  For example,...

I have SQL Server 2000 Dev Edition and Yukon Beta 2 running on the same machine.  No obvious issues...yet...