That did it. Thanks Mountain Lover. I've never had a need to
do that before.
Glad you pointed it out.
"Mountain Lover" <info@NOSPAMrecfusion.com> wrote in
> here's one way:
> SET NOCOUNT ON
> SELECT TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> WHERE TABLE_TYPE = 'BASE TABLE'
> SET NOCOUNT OFF
> Tim Carley