Hello,
I'm new to using SQL Server 2000. I recently created a table with about 12 columns by importing an already existing spreadsheet. When I look at the table in SQL Server Enterprise Manager, the grid of data is rather wide and I have to scroll to the right to see all columns. Even though I drag each of the column boudaries to the left to try to 'shrink' the view sizes, once I exit Enterprise Manager the changes are not applied/saved.
I would like to see all columns in one screen. Can someone advise if I can do it?
Also, many of the columns have sizes e.g., 8 or 10, that are larger than I need. Is there a simple way to modify column datatypes in a GUI view? Somehow, Design View does not let me make changes to the datatype sizes.
Thank you in advance.
I'm new to using SQL Server 2000. I recently created a table with about 12 columns by importing an already existing spreadsheet. When I look at the table in SQL Server Enterprise Manager, the grid of data is rather wide and I have to scroll to the right to see all columns. Even though I drag each of the column boudaries to the left to try to 'shrink' the view sizes, once I exit Enterprise Manager the changes are not applied/saved.
I would like to see all columns in one screen. Can someone advise if I can do it?
Also, many of the columns have sizes e.g., 8 or 10, that are larger than I need. Is there a simple way to modify column datatypes in a GUI view? Somehow, Design View does not let me make changes to the datatype sizes.
Thank you in advance.