Can i use SQLSMO in VS2003

Question

Hi

Since SQLSMO is available in .net 2.0 that how i can use it in VS2003 which compiled using .net 1.1. What can i do to this.

Is it is possible use of SQLSMO in VS2003?????

Plz clarify my doubt???? Thanks in advance...

Answer 1

In a word no; its a .net 2 function only. You could maybe abstract your data access through a webservice or similar though i don't know your structure to comment on the possibilities of doing that. Otherwise you can still use the SQL Server 2000 COM-based object model with SQL 2005/ 2000, SQL-DMO. This can be used to programmatically manage the SQL Servers.