Lowell,

I was hoping I could do this all in .NET managed code using some Microsoft.SqlServer.Management namespace. But I guess it is either not possible or way too complicated to...

Lowell,

I am using the 64bit version too. But it is R2. Under the folder path you mentioned, most of the assemblies are under Microsoft.SqlServer.Management namespace. In other words,...

Lowell,

That was an excellent example. One problem though. I can't find any of the assemblies you are using, on my installation. I have VS2010 with Sql Server...

Thanks all for the replies.

I already wrote an application using SMO to iterate through all the objects in a given database and populate a tree. The business logic in...

Hi all,

I am in the process of writing this application and is about 70% complete.  I don't want to post the code until I can fix all the bugs.  Once...