views:

362

answers:

2

As title, I need that to run an import script generated by SQL Server DB Publishing Tool. Would that work on Sql2000 server too? Also I have seen ppl reporting missing library issues related to GAC, which libraries I precisely need to include if I am not controlling the deployment server?

To know how this thing works you can check here in MSDN Forum. http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3947420&SiteID=1

I tested and indeed it works in my devbox with SQL2005 Express installed.

+1  A: 

Yes, SMO works on SQL Server 2000:

http://stackoverflow.com/questions/33457/smo-and-sql-server-70

Brent Ozar
A: 

Partially... so both the "yes" and "no" answers are correct

gbn