July 4, 2005 at 2:02 pm
However, I cannot directly view the same data in the dababase via SQL Server Enterprise Manager. It simply shows blank NOT <NULL>, so the data is definitly there and I can view the data through a textbox of my program.
Now as a test, I attempted to copy-n-paste the same hugh 4000 character text file direcly through the Enterprise Manager and recieved an error stating;
"The value you entered is not consistant with the data type or length of the column, or over the grid buffer limit."
So, I know the column 'Data Type" is varchar with an 8000 limit.
Q. I'm assuming by reasonalbe deduction that the MS SQL Enterprise Manager has some viewing limits?
I've read about changing the column Data Type to 'text', however the 'Length' is locked a 16.
Help.......................
July 5, 2005 at 3:34 pm
Enterprise manager is a management console built using the Microsoft MMC application. All it does is uses SQL DMO and t-SQL to issue statements to sql server to do various tasks.
It is not geared to be a data viewing application.
So what your seeing in enterprise manager is a Generic GUI Front end pasted on this huge and powerful RDBMS System.
Try this: In Enterprise Manager Try to increase the row Height of one of the rows in the grid. (Using your Mouse, and Dragging the row height bigger/Smaller.) Kinduv like Excel You should probably see some of your data.
Or you are in fact hitting some grid buffer limit. Having you tried selecting the values in query analyzer? It too is just a tool that interacts with Sql server. and it also has a buffer limit. Which you can set to 8000 in the Tools--->Options--,Results Tab.
Changing your datatype to text will further confuse enterprise manager. It does not even try to consume values from a text field.
July 6, 2005 at 12:38 pm
Thanks, I was thinking that MS SQL 2000 Query Analyzer has some limits.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply