Maximum row size for SQLExpress

I was just wondering if SQLExpress will have the same maximum row size
funcationality as SQL Server 2005. (being able to have a single row go
accross multiple pages and allow the entire row to exceed 8060 bytes)?
Thanks,
John Scott.
Hi
8060 applies. If you use the new datatypes NVARCHAR(max) and VARCHAR(max),
those data types get sliced up the SQL Server itself across multiple pages.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John Scott" <johnscott@.despammed.com> wrote in message
news:08F62DEB-4D56-4E0F-8560-403B46F513B0@.microsoft.com...
>I was just wondering if SQLExpress will have the same maximum row size
> funcationality as SQL Server 2005. (being able to have a single row go
> accross multiple pages and allow the entire row to exceed 8060 bytes)?
>
> Thanks,
> John Scott.
|||Yes, Express has the extended row size functionality introduced in SQL
Server 2005.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"John Scott" <johnscott@.despammed.com> wrote in message
news:08F62DEB-4D56-4E0F-8560-403B46F513B0@.microsoft.com...
>I was just wondering if SQLExpress will have the same maximum row size
> funcationality as SQL Server 2005. (being able to have a single row go
> accross multiple pages and allow the entire row to exceed 8060 bytes)?
>
> Thanks,
> John Scott.