Nice query but not exactly what I was hoping to find. I need to add the workstation name to our audit table.

Funny, this works perfect in SQL trace but...

Could you provide an example? When I run the following command no text shows for the SQL_TEXT

SELECT

spid

,sp.STATUS

...

That worked perfect. Thank You so much

SSCrazy that is absolutley perfect!!! Exactly what I needed. Thank you so much.

Thanks for the replies! I thought it wasn't possible but I wanted to ask just in case.

I will probably use the wrapper techinque.

We have a table with secure and unsecure...

What happens when you uncheck the 'use default' button?

Eirikur Eiriksson (2/14/2015)

---

Quick suggestion, query the sys.sql_dependencies view

SELECT

OBJECT_NAME(SD.object_id) AS OBJ_NAME

,OBJECT_NAME(SD.referenced_major_id) AS DEPENDENT_NAME

...

I got past the last post but I'm still struggling

DECLARE @Variable1 VARCHAR(MAX), @Variable2 VARCHAR(MAX)

DECLARE CursorName CURSOR FAST_FORWARD

FOR

SELECT TABLE_NAME

FROM dbo.MY_HISTORY_TBL

OPEN CursorName

FETCH NEXT

FROM CursorName

INTO @Variable1

WHILE @@FETCH_STATUS = 0

BEGIN...

So why can't I pass a varible to this script?

Declare @TableName VARCHAR(30)

SET @TableName = 'MY_HISTORY_TBL'

Select

(Name)

From sys.procedures

Where OBJECT_DEFINITION(object_id) Like @TableName

Order by (Name)

Go

I found the problem. Auto-refresh was enabled for the variable in the RDL. Thanks for the help!

Thanks every one especially SSCrazy, that was perfect. Now I can reverse engineer it.

I'm still getting an error. I added the truncate command just to give an idea of what I was trying to do.

"Conversion failed when converting the nvarchar value 'Select COUNT(*)...

I apologize that my statement confused the result I was looking for. How can I find the tables

below that failed and were never successful for the same day? Some tables...