Home Forums SQL Server 7,2000 Administration Detecting Detached Databases RE: Detecting Detached Databases
Andy Warren
SSC Guru
Points: 119902
More actions
August 14, 2002 at 5:57 pm
#434589
Nothing that I know of. One way would be to pull the list of mdf's, then query against (sysfiles? have to look) to see if its listed. Or you could just try to move or rename them, SQL wont let you if they are in use.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter