Main Menu

DBCC InputBuffer details for all spids for all databases PDF Print E-mail

 

DBCC Inputbuffer is the the coomand used to get the statement send from a client(SPID) to sqlserver.  

For instance DBCC INPUTBUFFER (81) will give the last statement from spid 81.

Here is the query to get the InputBuffer details for all SPID across all the databases.

Create proc udp_GetInputBuffer
@Dbnames varchar(1000)
As

Set NoCount On
Declare @Cnt int
Declare @GetSpid int
Declare @Dbname varchar(100)
Declare @EventType nvarchar(100)
Declare @EventInfo nvarchar(1000)

CREATE TABLE #Tempcur (
EventType NVARCHAR(100),
Parameters int,
EventInfo NVARCHAR(2000))

Create table #InputBuffer (ID int identity,Spid int,Dbname varchar(100),EventType nvarchar(100) null,
EventInfo nvarchar(1000) null,EventTime DATETIME DEFAULT CURRENT_TIMESTAMP)

Insert into #InputBuffer (Spid,Dbname)
Select spid,b.name from master.dbo.sysprocesses a
join master.dbo.sysdatabases b on a.dbid = b.dbid
WHERE CHARINDEX(',' + b.name + ',', @Dbnames) > 0
Set @Cnt = 1
While (Select max(ID) from #InputBuffer) >= @cnt
Begin
 Select @GetSpid = SPID,@Dbname = Dbname from #InputBuffer where ID = @Cnt

 Insert into #tempcur
 Exec('DBCC INPUTBUFFER('+@getspid+')')

 Select @EventType = EventType, @EventInfo = EventInfo from #tempcur

 Update #InputBuffer set EventType =@EventType,EventInfo =@EventInfo where ID = @cnt

 Truncate table #tempcur
 Set @Cnt = @cnt + 1

End
Select * from #InputBuffer order by Dbname

Drop Table #InputBuffer
Drop Table #tempcur

Set NoCount Off

Comments (31)
  • |205.209.140.xxx |2011-08-17 08:08:53 uggs sale  - uggs sale
    By all means, they look dangerously comfy,uggs sale, that I wouldn’t be surprised if you caught me accidentally walking down to belstaff jacket. Even so, I am feeling stress-fully torn between my belstaff jackets for comfort and their link to my Grandmother’s ugg canada. Surely, if I pop these on it doesn’t mean I’ve crossed the line between stylish and uggs sale? As long as Countryfile isn’t on that ugg canada.Perhaps it’s just my own irrational fear of picturing these slippers with ugg classic tall? If, however, these luxurious bailey button ugg were teamed with your favourite check pyjama trousers and an oversized t-shirt ugg bailey button, and accessorized with some bailey button uggs then I reckon we’d have an indoor-shoe winner.clw817
    ReplyQuote
  • |205.209.143.xxx |2011-08-24 06:23:27 ugg boots sale  - ugg boots sale
    Located in Canada,we provide you with best quality luxurious ugg boots sale. belstaff jackets are selling all around the globe. Choose from our belstaff jacket,and Lace Up boots as well as our enormously popular uggs canada. Kids and baby boots are also available, as well as slippers and scuffs and our uggs canada range and Desert boots. To complement our ugg boots canada we also offer top quality Pashmina shawls. Don't forget to visit our specials page and grab yourself a ugg classic tall boots!At ugg bailey button you will not only receive the best quality products, but highly competitive prices and excellent customer service. If you can't find what you are looking for or have questions on any of our bailey button uggs, please visit uggs bailey button or contact us for more information.clw824
    ReplyQuote
  • |66.79.161.xxx |2011-10-31 03:32:01 cdv  - cfdc
    The cost of designer children's clothing is significantly more than normal clothing, but sends a bold statement. There's definitely something for all parents and mulberry bags for 2011.Yet another trend you can see for this year's batch of kids' designer clothes is the mulberry handbag and worn-out look.
    ReplyQuote
  • |204.152.213.xxx |2011-12-05 03:00:34 anthentic air jodran
    Real Jordan Shoes For SaleWhen them calls for auto blogging and site-building epeat material fees. When them calls for auto blogging and site-building, I actually enjoy to work alongside WordPress. The fact is I actually get hold of them intelligent blogging and site-building to get WordPress.jordan air max fusion WordPress makes it very simple almost every any person because of flexibleness together with the styles of WordPress Extensions on the market from the current market so that you can automate a blog technique. Jordan max fusion 13 Have you actually ended the north face down jackets up witnessing a big photo at this moment you will conduct intelligent blog without the need of every dilemma the north face down jackets ? Air Jordan spizikeThe fact is I became pointed out the following greatly during Quintessential Autoblogging site whereby Now we have embraced lots of motor vehicle blogging and site-building strategies. Now enable’s observe how would you conduct a intelligent ...
    ReplyQuote
  • |66.197.219.xxx |2011-12-10 06:14:36 Anonymous
    New Orleans general NFL Jerseys promises owners savings of perhaps a quarter billion dollars a year but largely leaves intact the soft discount shoes wholesale salary cap system that the players fought hard to maintain.Stern and Deputy Commissioner Adam Silver announced the deal during a press conference, putting an end to nearly two years of difficult negotiations that resulted in the second shortened season in NBA history. Owners also agreed to an cheap nba jerseys expanded cheap nike air max revenue sharing plan, and Stern called both agreements "a watershed moment" for the league. The plan, nike free which will begin in 2013-14, more than quadruples the revenue currently shared by teams, with soccer shoes Stern saying they could now receive in excess of 20 million and at least six teams could pay 50 million into the plan.A outdoor shoes person familiar wholesale nike shoes with the negotiations says the framework of a three-team trade is in place to send New Orleans Horn...
    ReplyQuote
  • |63.223.126.xxx |2012-02-17 08:52:06 Wholesale Jordan Shoes  - Wholesale Jordan Shoes
    With the success of Space Jam film,Wholesale Jordan Shoes came in the demand for any stylish retro jordan shoes or maybe Air Jordan 11. Authentic Jordan ShoesThe White-Black-Red and Black in addition to Red retro jordan shoes were being released as "retros" in year 1994 once Jordan announced his retirement (for the first time and went on to play baseball with the whitesox) and the vintage jordan shoes being sold QUITE poorly.
    Air Jordan shoes is a brand of shoes produced through Nike and endorsed by ex-NBA player Michael Jordan.Jordan Shoes Online Right from the time these shoes were introduced, retro jordan shoes were promoted because the name was linked to that 95-1196 NBA champion,Air Jordan 2011 Michael Jordan.
    The famed star player wore them in the movie Space Jam and is thus popularly generally known as Space Jams. Previously released models which have been modified and re-released for sale are categorised as "retros". Since then, each couple of original retro ...
    ReplyQuote
Write comment
Your Contact Details:
Comment:
[b] [i] [u] [url] [quote] [code] [img]   
:D:angry::angry-red::evil::idea::love::x:no-comments::ooo::pirate::?::(
:sleep::););)):0
Security
Please input the anti-spam code that you can read in the image.
< Prev   Next >
 
Copyright 2009 SQL Server.in, Powered by Joomla!; Joomla templates by SG web hosting