Thread: From Visio 2003 to SQL
01-10-05, 16:07 #1Registered User
- Join Date
- Feb 2004
- Alpine Califormia
Unanswered: From Visio 2003 to SQL
I am in the process of creating another database for one of our departments, I'm creating a diagram of the structure in visio 2003. I'm done with the diagram but when I try to export to sql it wont let me. Anyone ever had this problem before??
This is the Error message I'm getting
ODBC Error: 01000
[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table 'Audit_Tbl' has been created but its maximum row size (20070) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Last edited by desireemm; 04-15-09 at 17:23.
01-10-05, 16:22 #2Annie's Dog Walker
Provided Answers: 6
- Join Date
- Nov 2004
- on the wrong server
This just means that SQL got grumpy because the datatypes that you have chosen for this one table result in a table bigger than it likes. It gives you the warning about inserts and updates but in my experience inserts and updates still work. I was on a project where I had to break up a bunch large tables that exceeded the maximum field length to fix the design but the application still worked before I got there. One thing I did notice is that DTS may not work sometimes in tables that exceed 8060. Your table should have still been created or altered or whatever. this is just a warning.If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.