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

  • Thread starter Thread starter Rupali
  • Start date Start date
R

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
 
I need to find out whether a database exists in SQL Server
or not through ASP.
Click to expand...

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
 
Back
Top