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 RiyaHi,<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.
]]>