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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
are you running the sql spy product?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.