|
Home > Archive > MS SQL Server > March 2006 > Find Views with NOEXPAND
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Find Views with NOEXPAND
|
|
| Daniel Jameson 2006-03-08, 8:23 pm |
| Hi,
Anyone out there know how to tell whether a view uses the WITH (NOEXPAND)
hint (other than searching the syscomments table for 'NOEXPAND')?
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www. childrensoncologygro
up.org
| |
| Dan Guzman 2006-03-09, 3:23 am |
| Another method is to script the view create statements and then search the
scripts for the NOEXPAND keyword.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Daniel Jameson" < djameson@childrenson
cologygroup.org> wrote in message
news:ejRg3RwQGHA.5924@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Anyone out there know how to tell whether a view uses the WITH (NOEXPAND)
> hint (other than searching the syscomments table for 'NOEXPAND')?
>
> --
> Thank you,
>
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www. childrensoncologygro
up.org
>
|
|
|
|
|