Link to home
Start Free TrialLog in
Avatar of dba123
dba123

asked on

create table #tmpDBCCinputbuffer

I am trying to figure out what the hell this is.  It's running constanly when I view the activity monitor in SQL 2005 against a SQL 2000 db

create table #tmpDBCCinputbuffer ([Event Type] nvarchar(512), [Parameters] int, [Event Info] nvarchar(512))
insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(310)')
select [Event Info] from #tmpDBCCinputbuffer

is this something the system needs in SQL 2005 or SQL 2000?  When I try to kill the process it tells me I cannot kill my own process
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
are you running the sql spy product?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial