Thanks I will try this method

Hi Matt,

I have another question for you:

In ADODB, when you loop through a recordset, you would use the movenext method of the recordset, and you could access the data like...

Hi Matt,

It's looking better now. Here is what I was trying to do:

The SMO stuff is for the login part of the app, so I want to give a list...

Hi Matt,

Thanks for all you help, considering that you don't even know me. I am sure that this code will work, however (and not to sound ungrateful, which I probably...

Hi Matt,

Thanks for the reply. I am not trying to count the number of databases. I am fine with that part of the application.

What I was actually trying to...

HI Tim,

Thanks for your help. It works great. Now for my next question:

I see that the datareader cannot get a recordcount. Although I could use the old ADODB.Recordset object, I...

Hey Tim,

Maybe you know how to get a list of databases on a particular server?

Regards

Leonard