General information
Forum:
Microsoft SQL Server
Title:
What you see is NOT what you get
Can someone tell me how to resolve the following problem.
I'm extracting data from specific columns in a number of tables.
This data is used to create and populate a new table.
Using OpenTable in Enterprise Manager, I am able to see all the data correctly. For the purpose of this discussion, I see the data in all 10 columns.
HOWEVER, using DesignTable in Enterprise Manager, I CAN ONLY SEE 5 COLUMNS.
Trying to subsequently add rows to this new table results in truncation errors.
I'm hoping someone has experienced this before and has an explanation and a solution.
Thanks in advance.
Keith
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only