Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iswan
Starting Member
28 Posts |
 Posted - 2007-06-11 : 10:58:19
|
| I am trying to create a view in sql server from various tables. The combination of tables may be contain more than 1024 fields. So It is showing errorNo: 4505Error Msg: Create view failed because column 'unnumbered tables' in view 'dbo.scViewJoins' exceeds the maximum of 1024 columnsThe view is not creating. I am using sql server2000. How can I handle it?RegardsIswan |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-11 : 11:01:11
|
| Do you need to return all the columns? 1024 is a lot for users to deal with - is there anything that actually needs all those columns or are you trying to use a single view to service many clients.If that's the case then create different views for the different needed colunms.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
create view in sql server (column exceeds 1024)