MDF文件问题

Question

请问,同一个MDF文件,允许同时被2个不同的sql客户端程序,附加为数据库嘛?

Answer 1

Hi,

同一个MDF文件无法在同一时间被两个SQL客户端进行引用，否则将会触发"文件已在另一程序中打开"的异常。

Regards,

Kyle

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

同一个MDF文件,被1个sql客户端程序附加後，

必须分离该数据库文件，才能被另1个sql客户端程序附加。

如同现在婚姻法的规定，夫妻必须办理离婚後才能重新结婚。