I have SELECT statement in VB6 application. It is used to populate
ADODB.Recordset.
It works fine when I connect to SQL 2000 and SQL 2005 databases. It works
fine as well if I run it inside of  Mangement Studio or Enterprise Manager

I was restoring a database in SQL Server 2005 express edition. Due to a
malfunction, system restarted.
Now when I try to access the database, the status shows as "Restoring
Database". I have tried to restart SQL Server and PC, but there is no

Does anyone know if an existing SQL 2005 box can also host a MSDE db if the
comm ports are different ?
Thanks in advance!!

I have a SQL 2000 maintenance program written in VB6 that I update and
distribute when I want to make changes to SQL 2000 database I have to
support.  I have to update the program to use SQL 2005, but can't get SQLDMO
to work with SQL 2005.