Devlec.com Javacstudy.com
MyÆäÀÌÁö |  óÀ½»ç¿ëÀÚ ÀÌ¿ë¾È³» |  ÀÌ¿ë¹®ÀÇ |  ȸ»ç¼Ò°³

¡á Æ©ÅÍ°Ô½ÃÆÇ Article Number : 27576

Àü¼®È¯´ÔÀÌ ÀÛ¼ºÇϽŠ³»¿ëÀÔ´Ï´Ù. 2017-08-09   |   Refer : 387
÷ºÎÆÄÀÏ : None   À̹ÌÁö : None ŸÀÔ : °ø°³±Û

¾È³çÇϼ¼¿ä. °­»ç´Ô °­ÀǸ¦ ¿­½ÉÈ÷ µè°í ÀÖ´Â ¸¸Çеµ ÀÔ´Ï´Ù.

°­ÀÇ APS.NET ÇÁ·ÎÁ§Æ® Part2 50¹ø °­ÀÇ µû¶óÇϱâ ÁßÀε¥

¾Æ·¡¿Í °°ÀÌ ¿À·ù°¡ ¹ß»ý ÇÕ´Ï´Ù. È®ÀÎ ÇÏ½Ã¾î ´äº¯ ºÎŹµå¸³´Ï´Ù.

============================================================
(43,1): SQL72014: .Net SqlClient Data Provider: ¸Þ½ÃÁö 5061, ¼öÁØ 16, »óÅ 1, ÁÙ 5 ALTER DATABASE failed because a lock could not be placed on database 'MemoEngine'. Try again later.
(39,0): SQL72045: ½ºÅ©¸³Æ® ½ÇÇà ¿À·ùÀÔ´Ï´Ù. ½ÇÇàÇÑ ½ºÅ©¸³Æ®:
IF EXISTS (SELECT 1
FROM [master].[dbo].[sysdatabases]
WHERE [name] = N'$(DatabaseName)')
BEGIN
ALTER DATABASE [$(DatabaseName)]
SET CONTAINMENT = NONE
WITH ROLLBACK IMMEDIATE;
END

(43,1): SQL72014: .Net SqlClient Data Provider: ¸Þ½ÃÁö 5069, ¼öÁØ 16, »óÅ 1, ÁÙ 5 ALTER DATABASE statement failed.
(39,0): SQL72045: ½ºÅ©¸³Æ® ½ÇÇà ¿À·ùÀÔ´Ï´Ù. ½ÇÇàÇÑ ½ºÅ©¸³Æ®:
IF EXISTS (SELECT 1
FROM [master].[dbo].[sysdatabases]
WHERE [name] = N'$(DatabaseName)')
BEGIN
ALTER DATABASE [$(DatabaseName)]
SET CONTAINMENT = NONE
WITH ROLLBACK IMMEDIATE;
END

ÀÏ°ý 󸮸¦ ½ÇÇàÇÏ´Â µ¿¾È ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù.

===========================================================================


·Îµù½Ã°£ : 0.016 sec
±Û ´äº¯   ±Û ¼öÁ¤   ±Û »èÁ¦   ±Û ¸ñ·Ï


   
   
Ȩ ȸ»ç¼Ò°³ ÀÌ¿ë¾à°ü °³ÀÎÁ¤º¸ º¸È£Á¤Ã¥ ÀÌ¿ë¾È³» Q&A FAQ Guide