what do you mean by "present sql queries in graphical format". do you mean the graphical representation of the execution plan or something else?

If I understand what you are saying correctly, you just need to "refresh" the view in ssms.

answered my own question on this and thought I'd share in case the next guy who comes along is trying to figure it out. I took the server offline,...

Actually you didn't answer my question at all. My question is how to return the SQL statement.

Jerk.

I think you misunderstand the question... but I figured it out some time ago. this is what I'm doing:

USE [DBA]

GO

/****** Object: Table [dbo].[blockingreport2013] Script Date:...

Yeah, everything is in simple mode so that should work. Give give SSIS a try. Maybe with a small batch size I"ll get periodic commits.

Thanks

Thanks Gail,

That makes sense, but is there any way to...

Yep, look for a new job, but...

don.schaeffer (4/9/2010)

---

This script might get what you want:

select

WaitTime = cast( textdata as xml ).value( '/blocked-process-report[1]/blocked-process[1]/process[1]/@waittime','varchar(20)' ),

BlockingQuery = cast( textdata as xml ).value( '(/blocked-process-report/blocking-process/process/inputbuf)[1]','varchar(200)'),

BlockingSpid = cast( textdata as xml ).value(...

So, I posted on a Friday afternoon and go no responses... maybe this reply on a Monday morning will help? Still can't get it, would appreciate a tip.

You might be interested in this article I wrote a while back about automatic checking of backup and error log entries via PowerShell: http://www.sqlservercentral.com/articles/powershell/76561/

while admin is not strictly required, and probably it's ideal for the service account to not be admin, there are lots of different permissions required by the service account. ...

here's some code I used once upon a time to bring back rows from the errorlog that were "interesting"... you could create a proc to do something like...

we should do at least one more round of this... someone will surely comment again in 2016 😉

In my case, I'm using reporting services subscriptions to mail out the report. So I didnt want to use that logic in a stored proc because once the report...