mssql 2k: how do i find a field in a database

[ecka00]

looking for an sp or tsql that will allow me to locate a specific field name in a database, eg. table that field exists in.

[MAK]

use yourdatabasename
go
declare @columnnametosearch varchar(128)
--update the @columnnametosearch with your desired column
set @columnnametosearch='name'
select object_name(id) as Tablename,name as Columnname from syscolumns where name =@columnnametosearch

[MAK]

if you like to search the entire server.

http://www.databasejournal.com/scrip...le.php/3625661