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.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.
Showing posts with label diagram. Show all posts
Showing posts with label diagram. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
From databasediagram to T-SQL
Hello, i have made a diagram in a SQL Express database.
i would like to know how to get this to T-SQL CREATE TABLE script?
I don't think you can use SQL Express to do it but we are still in beta so use the link below and download the developer edition to do it. How you use the OLTP(online transaction processing) management studio it is like your Enterprise manager in SQL Server 2000. Hope this helps.
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx#EBAA|||
http://forums.asp.net/1052509/ShowPost.aspx
i would like to know how to get this to T-SQL CREATE TABLE script?
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx#EBAA|||
Thanks i understand. I think this is a pretty imporant feature. Because if i have made a Table Diagram in VWD and would like to show it to a friend, i want to be able to convert this diagram to a SQL CREATE TABLE txt script. so my friend can just copy this SQL txt script into his VWD and show up exactly the same tables.
|||Hello, i noticed that i actually can get this diagram to a T-SQL CREATE TABLE script, by clicking on the "Generate change script", but this "menubutton" is only available if i made a change to the database, and because of this i cannot just generate the script when i want to, i have to make changes to the database to do it, i think this is a unnecessary step, this "menubutton" "generate change script" should be available all the time, and it should be renamed to "generate script" so i can generate the T-SQL script whenever i want to.|||Try the post below and test drive the latest CTP, it may be different. Hope this helps.http://forums.asp.net/1052509/ShowPost.aspx
Subscribe to:
Posts (Atom)