Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2005-08-11 : 18:52:12
|
| how can I find the maximum row size of table and check whether it exceeds the limit or not |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-11 : 18:59:45
|
| An easy way would be to script the tables out using Generate SQL Script wizard in EM. Then run the script on a test box. Any table that gives you the warning message is over the limit.Tara |
 |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-11 : 19:00:44
|
quote:
Originally posted by sqllearner
how can I find the maximum row size of table and check whether it exceeds the limit or not
The max row size in SQL Server 2000 is 8060 bytes, and you can't exceed it. Is that what you mean?The max row size for a particular table is defined by adding the max lengths of all columns in it - again, its not possible to exceed it.ThanksPaul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-11 : 19:03:32
|
Ah - just realized what you mean - which tables have the potential to go over the max row size. See Tara's answer  Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
Maximum Row Size