Attach- detach option in SQL 7 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Attach- detach option in SQL 7

Hi, I want to attach a databse in SQL 7. I can do it using sp_attach_db. But is there an "attach-detach" option in the enterprise manager in SQL 7. If yes, please tell me where this option is. Riya Riya
Hi,<br />I feel its not their in EM.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Yes it is not available with SQL 7 EM tools, only added in SQL 2000 and you may use SP_ATTACH_DB & SP_DETACH_DB statements to accomplish the task. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>