{"id":143,"date":"2012-04-16T12:16:36","date_gmt":"2012-04-16T12:16:36","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/04\/16\/what-is-the-maximum-size-of-varbinarymax-column-in-sql-server\/"},"modified":"2012-04-16T12:16:36","modified_gmt":"2012-04-16T12:16:36","slug":"what-is-the-maximum-size-of-varbinarymax-column-in-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/04\/16\/what-is-the-maximum-size-of-varbinarymax-column-in-sql-server\/","title":{"rendered":"What is the Maximum size of varbinary(max) column in SQL Server?"},"content":{"rendered":"
table.hovertable {
\nfont-family: verdana,arial,sans-serif;
\nfont-size:11px;
\ncolor:#333333;
\nborder-width: 1px;
\nborder-color: #999999;
\nborder-collapse: collapse;
\n}
\ntable.hovertable th {
\nbackground-color:#c3dde0;
\nborder-width: 1px;
\npadding: 8px;
\nborder-style: solid;
\nborder-color: #a9c6c9;
\n}
\ntable.hovertable tr {
\nbackground-color:#d4e3e5;
\n}
\ntable.hovertable td {
\nborder-width: 1px;
\npadding: 8px;
\nborder-style: solid;
\nborder-color: #a9c6c9;
\n}<\/p>\n
What are the maximum Bytes per varbinary(max) column in SQL Server?
\nSQL Server Supports 2^31-1 Bytes per varbinary(max) Column.<\/p>\n
Max Capacity For<\/th>\n | SQL Server 2012<\/th>\n | SQL Server 2008 R2<\/th>\n | SQL Server 2008<\/th>\n | SQL Server 2005<\/th>\n<\/tr>\n |
---|---|---|---|---|
\nMaximum Bytes per varbinary(max) column in SQL Server\n<\/td>\n | \n2^31-1 Bytes\n<\/td>\n | \n2^31-1 Bytes\n<\/td>\n | \n2^31-1 Bytes\n<\/td>\n | \n2^31-1 Bytes\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n |