Accessing a SQL Server View in an Data View

I have STS 2003 with all the latest patches and service packs. I also
have a SQL Server with all the latest patches and service packs. I have
created a data view in the past which returned information from a
specific SQL Server table. 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 tables are listed as Type table or
view. But I only see views 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:51 CST 2005

Nevermind, I figured out what my problem was.

Irwin Fletcher wrote:
> I have STS 2003 with all the latest patches and service packs. I also
> have a SQL Server with all the latest patches and service packs. I have
> created a data view in the past which returned information from a
> specific SQL Server table. 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 tables are listed as Type table or
> view. But I only see views 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.

Engelbert
Mon Dec 12 23:28:45 CST 2005

Tell us the solution ?

"Irwin Fletcher" <noffletchspam@nogmailspam.com> wrote in message
news:%231SeyTz$FHA.292@TK2MSFTNGP14.phx.gbl...
> Nevermind, I figured out what my problem was.
>
> Irwin Fletcher wrote:
>> I have STS 2003 with all the latest patches and service packs. I also
>> have a SQL Server with all the latest patches and service packs. I have
>> created a data view in the past which returned information from a
>> specific SQL Server table. 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 tables are listed as Type table or
>> view. But I only see views 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.