SELECT login_name, COUNT(session_id) AS session_Count FROM sys.dm_exec_sessions GROUP BY login_name; SELECT A.spid, A.login_time, A.loginame, A.last_batch, A.status, A.program_name, A.cmd, B.client_net_address FROM sys.sysprocesses A?JOIN sys.dm_exec_connections B ON A.spid = B.session_id where a.loginame = 'aipuser'; /* ÇöÀç Connection Pool ¼ö */ SELECT DB_NAME(dbid) AS 'Database', COUNT(dbid) AS 'Connection Pool Count' FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid; /* Àüü Connection Pool ¼ö */ SELECT COUNT(dbid) AS 'Total Connection Pool Count' FROM sys.sysprocesses WHERE dbid > 0; /* ÃÖ´ë Connection Pool ¼ö */ SELECT * FROM sys.configurations WHERE name = 'user connections'; /* ÇöÀç ¿¬°áµÈ ¼¼¼Ç Á¤º¸ */ SELECT S.SPID AS '¼¼¼Ç ID', S.LOGINAME AS '·Î±×ÀÎ À̸§', S.LOGIN_TIME AS '·Î±×ÀÎ ½Ã°£', S.LAST_BATCH AS '¸¶Áö¸· Àϰý ó¸® ½Ã°£', C.CLIENT_NET_ADDRESS AS 'Ŭ¶óÀÌ¾ðÆ® IP ÁÖ¼Ò' FROM sys.sysprocesses S, sys.dm_exec_connections C WHERE S.spid = C.SESSION_ID ORDER BY S.LOGIN_TIME DESC; SELECT DB_NAME(dbid) as DBÀ̸§, COUNT(dbid) as Á¢¼ÓÀÚ¼ö FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid; SELECT S.spid, S.loginame, S.login_time, S.last_batch, C.client_net_address FROM sys.sysprocesses S, sys.dm_exec_connections C WHERE S.spid = C.session_id; SELECT @@identity; DBCC checkident(tb_aip_label, reseed, 0); -- Áõ°¡°ª ÀÚµ¿ ÁöÁ¤ (±âº» ¼³Á¤) SET IDENTITY INSERT tb_aip_label OFF; -- test : Å×À̺í¸í -- Áõ°¡°ª ¼öµ¿ ÁöÁ¤ SET IDENTITY INSERT tb_aip_label ON; -- ½ÃÀÛ°ª ÀçÁöÁ¤ DBCC CHECKIDENT (tb_aip_label, RESEED, 0) -- 0 : ½ÃÀÛ°ª -- ÇöÀç ¼¼¼ÇÀÇ Å×ÀÌºí¿¡¼­ »ý¼ºµÈ ¸¶Áö¸· ID °ª ¹Ýȯ (Á¦ÇÑ x) SELECT @@IDENTITY -- ÇöÀç ¼¼¼ÇÀÇ Å×ÀÌºí¿¡¼­ »ý¼ºµÈ ¸¶Áö¸· ID °ª ¹Ýȯ (ÇöÀç ¹üÀ§¸¸) SELECT SCOPE_IDENTITY() -- ÁöÁ¤µÈ Å×ÀÌºí¿¡¼­ »ý¼ºµÈ ¸¶Áö¸· ID °ª ¹Ýȯ SELECT IDENT_CURRENT(tb_aip_label) -- Å×À̺í¸í(test) SELECT message_id AS Error, severity AS Severity, [Event Logged] = CASE is_event_logged WHEN 0 THEN 'No' ELSE 'Yes' END, [text] AS [Description] FROM sys.messages WHERE language_id = 1040 /* replace 1040 with the desired language ID, such as 1033 for US English */ ORDER BY message_id;