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=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
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.
]]>