SQLDMO Object on client

[CP60]

Will the client have this object installed also on the client when sql server 2005 express is installed, or just with the standard+ version as I have?

If so, will the BulkCopy work with the Express version (I understand that DTS isn't available with the Express version)

 

[gmmastros]

NO.

2005 uses SQL-SMO instead of DMO. Have you thought about installing DMO?

Microsoft SQL Server 2005 Backward Compatibility Components

http://www.microsoft.com/downloads/...60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[CP60]

Thanks gmmastros.
But now I am confused.
I wonder where I got this DMO. I thought it was installed with SQL 2005.

Anyways, are you saying I could be using SMO instead? Is that basically the same thing as DMO but just for SSQL 2005? Is that installed with the Express edition? If not, can that be redistributed?