[RESOLVED] SQL Server 2005: replacement for SQLDMO

SQLDMO only works for SQL Server 2000 (at least that what I believe), I need to replace it so that it will work on SQL Server 2005 and probably for SQL Server 2008 also in the future.

TIA

SQLDMO does work for later versions but it's preferable to use SMO. It's .NET-based instead of COM-based.

http://msdn.microsoft.com/en-us/library/ms162169.aspx

And it's more powerful too..

-tg

Quote:

---

Originally Posted by jmcilhinney

SQLDMO does work for later versions but it's preferable to use SMO. It's .NET-based instead of COM-based.

http://msdn.microsoft.com/en-us/library/ms162169.aspx

---

Hmmnnn... Care to cite a sample that would make SQLDMO connect with SQL Server 2005 database?

Quote:

---

Originally Posted by dee-u

Hmmnnn... Care to cite a sample that would make SQLDMO connect with SQL Server 2005 database?

---

Code:

---

oSQL.LoginSecure = true;
oSQL.Connect(@"SERVER\SQLEXPRESS", null, null);

---

Works for me, just in case somebody else is interested.