Detach database in SQL Server 2005 using script

Here is the script from which you can easily do this. just pass $(dbname) with database name you want to detach.


USE [master]
GO
-- detach farm config DB
EXEC master.dbo.sp_detach_db @dbname = N'$(dbname)', @keepfulltextindexfile=N'true'
GO



Happy Coding...