|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
using sqldmo to get some property of db
how to make use of sqldmo to
1. get DB name?? (the physical name of the database) 2. perform an auto clear on all connection using the DB (or maybe running some stored proc or query?), so that the DB is no longer used by any connections and can be detached anytime without error saying the "db is in use" |
|
#2
|
|||
|
|||
|
try this query :
Quote:
may this solution can help Rgds, Tonny Soeroso |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > using sqldmo to get some property of db |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|