查询包含指定字段的所有表名的SQL脚本

select [name] from sysobjects where [id] in (select [id] from syscolumns where [name]='ReceiptNbr')   --

ReceiptNbr为想要查询的字段名