Find all views, stored procedures etc that use a table column


SELECT OBJECT_NAME(sd.id) Dependent_Object,
(SELECT xtype FROM sysobjects so WHERE so.id = sd.id) Object_Type
FROM sysobjects so
INNER JOIN syscolumns sc ON so.id = sc.id
INNER JOIN sysdepends sd ON so.id = sd.depid AND sc.colid = sd.depnumber
WHERE so.id = OBJECT_ID('TABLE_NAME')
AND sc.name = 'TABLE_COLUMN'


Requested registry access is not allowed

After uninstalling Visual Studio 2010 BETA, one of the bugs I received in Visual Studio 2008 was
Requested Registry Access is not allowed while trying to add a class to my solution.

To fix this, download and install SubInACL which is a command line tool.  After installing this, create a .bat file and put this lines in it:

subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.vbproj.9.0 /grant=administrators=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.vbproj.9.0 /grant=users=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.vbproj.9.0 /grant=system=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.csproj.9.0 /grant=administrators=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.csproj.9.0 /grant=users=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.csproj.9.0 /grant=system=f

Save the bat file into C:\Program Files\Windows Resource Kits\Tools or Program Files (x86) depending on your system, and run it.

problem fixed!