SQL에서 사용중인 프로시저 조회 > db

[MS-SQL]에서 사용중인 프로시저

 

조회 프로시저

 

-------------------------------------------------------

 

CREATE PROCEDURE [PZZ0_0_iERP_프로시저_현황_조회]
                                 (@사용자          [VARCHAR](255),
                                  @호스트          [VARCHAR](255),
                                  @응용프로그램 [VARCHAR](255))

AS

SELECT
                    [master].[dbo].[sysprocesses].spid AS spid,
                    [master].[dbo].[sysprocesses].open_tran AS 차단하는중,
                    [master].[dbo].[sysprocesses].ecid AS 차단주체,
                    [master].[dbo].[sysprocesses].login_time AS 로그인시간,
                    [master].[dbo].[sysprocesses].last_batch AS 마지막_일괄_처리,
         RTRIM([master].[dbo].[sysprocesses].loginame) AS 사용자,
         RTRIM([master].[dbo].[sysprocesses].hostname) AS 호스트,
         RTRIM([master].[dbo].[sysprocesses].program_name) AS 응용프로그램,
         RTRIM([master].[dbo].[sysprocesses].status) AS 상태
FROM           [master].[dbo].[sysprocesses]
WHERE        ([master].[dbo].[sysprocesses].open_tran <> 0)
           AND ([master].[dbo].[sysprocesses].loginame LIKE @사용자)
           AND ([master].[dbo].[sysprocesses].hostname LIKE @호스트)
           AND ([master].[dbo].[sysprocesses].program_name LIKE @응용프로그램)
ORDER BY    [master].[dbo].[sysprocesses].spid

 

GO