Rename a SQL Server 2000 datatabase

I was looking for a quick way to rename a SQL SERVER 2000 database I found the information handy. EXEC sp_dboption 'OldDbName', 'Single User', 'TRUE' EXEC sp_renamedb 'OldDbName', 'NewDbName' EXEC sp_dboption 'NewDbName', 'Single User', 'FALSE' Thankx to Jason Fisher. His short artcile has explanation for this code.