Of course even the thing you just posted can't possibly take into account complex things. What about a cte in a proc that has a where statement and the value...

srik.kotte (11/29/2012)

---

DECLARE @sql VARCHAR(MAX)

SET @sql = ' USE ?; SELECT ''?'' AS DATABASE_NAME,

sys.schemas.name AS [Schema Name], sys.objects.name AS [Object Name] , ...

No problem. Sometimes it just takes a new set of eyes looking at it. 😛

Nice job posting ddl and sample data along with desired output. However it is totally unclear what the logic should be here.

This looks somewhat like an adjacency list except it...

valeryk2000 (11/29/2012)

---

SELECT UniqueIDSystem

,FullLastFirstName

,Position PositionOrig

,case Position

...

It will most likely take some manual manipulation to get only those that have that column in the where clause. Keep in mind that you are dealing with varchar data....

¡de nada

What you have looks like it should work. Not sure what you mean by not working. You did mention that you want to...

davas (11/29/2012)

---

Thanks both for your responses regarding the heap. I guess I'd like to find a way to detect if the same is happening on other tables too (with a...

You might want to take a look at RedGate SQL Search.

The OP...

davas (11/29/2012)

---

Thank you both for your quick replies! I've created a clustered index and now the table reports as being 600MB as expected so that's great.

Just wondered why the sp_spaceused...

Not sure what you are looking for here exactly. There is nothing...

adonetok (11/29/2012)

---

I need to take the value from one text box txtSupply, assign it to a variable and then insert it into a column (Supply, int) in SQL table.

What...

SQLCrazyCertified (11/29/2012)

---

I need to find any failed EXECUTE attempt in the past two days on a particular Stored Procedure using any Login, from the application server side.

How can I achieve...