Accessing a SQL Server View in an Data View

I have created a data view in the past which returned information from a
specific SQL Server table. I'd like to create a data view that returns
information from a specific SQL View.

When I go to create a data view and I look at the list of Tables, views
or stored procedures, I only see stored procedures and tables. All of
the items are listed as type "table or view". But I only see tables there.

I originally thought I had a permissions issue, so I tried it as sa and
that didn't change anything either.

Is there something on my SQL Server that I need to change? Or is there
another way that I should be doing this in Front Page (or elsewhere)?

TIA for any ideas.

Irwin
Mon Dec 12 09:58:34 CST 2005

Nevermind, I figured out what my problem was.

Irwin Fletcher wrote:
> I have created a data view in the past which returned information from a
> specific SQL Server table. I'd like to create a data view that returns
> information from a specific SQL View.
>
> When I go to create a data view and I look at the list of Tables, views
> or stored procedures, I only see stored procedures and tables. All of
> the items are listed as type "table or view". But I only see tables there.
>
> I originally thought I had a permissions issue, so I tried it as sa and
> that didn't change anything either.
>
> Is there something on my SQL Server that I need to change? Or is there
> another way that I should be doing this in Front Page (or elsewhere)?
>
> TIA for any ideas.