problem about checking of a particular database in SQL Server through ASP

[Rupali]

I need to find out whether a database exists in SQL Server
or not through ASP. I will open the connection for that
database only if the database exists.Can someone help me
out!!


Thanks

 

[Tim Ferguson]

I need to find out whether a database exists in SQL Server
or not through ASP.

If you connect to the Master database, you can use one of the system stored
procedures (I think it's called spDatabases?) to scan the databases on the
server.

HTH


Tim F