Hi,
Is there a store procedure or a simple way to find all objects (
sps, views... ) that access a particular column of a particular table?
Thanks.

Komp.

Well, there is the old brute-force way: rename the column of interest
and see what breaks.
This actually can work pretty well if you think about it. You can
easily write a cursor that loops through syscomments and creates a copy
of every object in your database. Those that fail were the ones trying
to reference the column in question. This will not work for select
*'s, or with dynamic sql, but anywhere in an object where you reference
the named column explicitly, this would likely help. You could narrow
down the scope of this by joining on sysdepends, or just use that as a
crib sheet and do it by hand.

Sorry it's not more elegant. Maybe someone else has a good idea...

I felt stupid, because after posting that last message, I realized you
have a very simple solution:

select
o.name, c.text
from syscomments c
INNER JOIN sysobjects o
ON (c.id = o.id)
WHERE c.text like '%<my column>%'
AND c.text like '%<my table>%'

Hope this helps