New view not showing columns

[Rachel]

Any idea why I cannot see (in Enterprise Manager) all the coulmns of a selected table? All I get is * all columns - not each one, meaning I cannot select individual columns in my new view. Could it be the version? I am running SQL 7.0 SP1

Thanks

[RickD]

Is your View doing a SELECT * ? If so this may be the problem. Use SELECT Column1, Column2 etc..

Also, I would suggest being on at least SP2.

Rick


------------
Rachel at 7/9/01 6:56:18 PM

Any idea why I cannot see (in Enterprise Manager) all the coulmns of a selected table? All I get is * all columns - not each one, meaning I cannot select individual columns in my new view. Could it be the version? I am running SQL 7.0 SP1

Thanks

Thanks for your response Rick. It's a new view I am trying to create - I don't get any choice on what cloumns to select - there's only *. I have since discovereed that this only applies to the one database on this server. If I try to create a new view in another db on the same server, I do get the option of selecting coulmns. Perhaps there is a db option or config setting?


------------
RickD at 7/10/01 8:26:03 AM

Is your View doing a SELECT * ? If so this may be the problem. Use SELECT Column1, Column2 etc..

Also, I would suggest being on at least SP2.

Rick


------------
Rachel at 7/9/01 6:56:18 PM

Any idea why I cannot see (in Enterprise Manager) all the coulmns of a selected table? All I get is * all columns - not each one, meaning I cannot select individual columns in my new view. Could it be the version? I am running SQL 7.0 SP1

Thanks