The actual code for views, rules, defaults, triggers, CHECK constraints, 
DEFAULT constraints and stored procedures are stored in the syscomments 
table. The column TEXT in the syscomments table contains the actual code for 
all these objects.

SQL Sever maintains a database system table named sysdepends. SQL Server 
uses this table to store object dependencies. This table only contains 
information about objects that are dependent upon other objects.

http://www.databasejournal.com/features/mssql/article.php/3571026/Finding-Database-Object-Dependencies.htm

Dar kas sauna i galva yra tai, kad MS SQL galima sp koda "apsaugoti" (tipo 
CREATE PROCEDURE sp_name WITH ENCRYPTION), tada syscomments lentoj jis nera 
sugomas atviru tekstu, o uzkoduojamas pagal kazkoki algoritma. Gal tame suo 
pakastas...

Dar galima cia zvilgtelet, gal pades...
http://weblogs.sqlteam.com/brettk/archive/2005/04/28/4830.aspx#1564

Sekmes

"Jornada Del Muerto" <agira@TRINTIgmx.co.uk> wrote in message 
news:i3m05m$oev$1@trimpas.omnitel.net...
> Sveiki,
>
>    Taisau vieno veikejo gan didoka DB, daryta viskas per T-SQL dirbant su 
> lentom ir paziurejus dependencies ne visus parodo nors jei padarau 
> "generate all scripts" matau kad dirbama su ta lenta ir dirba gan daug 
> proceduru su ja, bet to nematau dependencies ziuredamas... tai keblu galus 
> atrinkti.
>
>    DB MSDE 2000, o ziuriu ja restorines ant MSSQL 2005 Express, gal 
> imanoma kaip nors refreshint dependencies kad butu visi ar bet kokiu kitu 
> budu suzinoti tikrus dependencies?