{"id":6878,"date":"2018-12-24T08:27:54","date_gmt":"2018-12-24T08:27:54","guid":{"rendered":"https:\/\/dbtut.com\/?p=6878"},"modified":"2018-12-24T08:27:54","modified_gmt":"2018-12-24T08:27:54","slug":"invalid-attempt-to-getbytes-on-column","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/","title":{"rendered":"Invalid attempt to GetBytes on column"},"content":{"rendered":"<p>&nbsp;<\/p>\n<h3>ERROR:<\/h3>\n<p>An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column &#8216;xxx&#8217;. The GetBytes function can only be used on columns of type Text, NText, or Image.<\/p>\n<h3>EXPLANATION:<\/h3>\n<p>You may see an error message when you run a query against a table in a SQL Server database from SQL Server Management Studio.<\/p>\n<h3>SOLUTION:<\/h3>\n<p>In my case, the problem was to run a query that I ran against the SQL Server 2008 database from the 2005 version of SQL Server Management Studio.\u00a0You must use a version of SSMS that is compatible with the version of the database that you are using.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6878\" class=\"pvc_stats all  \" data-element-id=\"6878\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; ERROR: An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column &#8216;xxx&#8217;. The GetBytes function can only be used on columns of type Text, NText, or Image. EXPLANATION: You may see an error message when you run a query against a table in a SQL Server database from SQL &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6878\" class=\"pvc_stats all  \" data-element-id=\"6878\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":423,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6878","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":272,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Invalid attempt to GetBytes on column - Database Tutorials<\/title>\n<meta name=\"description\" content=\"An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column &#039;xxx&#039;. The GetBytes function can only be used on columns of type Text, NText, or Image.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Invalid attempt to GetBytes on column - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column &#039;xxx&#039;. The GetBytes function can only be used on columns of type Text, NText, or Image.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-24T08:27:54+00:00\" \/>\n<meta name=\"author\" content=\"Ekrem \u00d6nsoy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ekrem \u00d6nsoy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"Invalid attempt to GetBytes on column\",\"datePublished\":\"2018-12-24T08:27:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/\"},\"wordCount\":114,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/\",\"name\":\"Invalid attempt to GetBytes on column - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-12-24T08:27:54+00:00\",\"description\":\"An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column 'xxx'. The GetBytes function can only be used on columns of type Text, NText, or Image.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Invalid attempt to GetBytes on column\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\",\"name\":\"Ekrem \u00d6nsoy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"caption\":\"Ekrem \u00d6nsoy\"},\"description\":\"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.\",\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Invalid attempt to GetBytes on column - Database Tutorials","description":"An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column 'xxx'. The GetBytes function can only be used on columns of type Text, NText, or Image.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/","og_locale":"en_US","og_type":"article","og_title":"Invalid attempt to GetBytes on column - Database Tutorials","og_description":"An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column 'xxx'. The GetBytes function can only be used on columns of type Text, NText, or Image.","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-24T08:27:54+00:00","author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"Invalid attempt to GetBytes on column","datePublished":"2018-12-24T08:27:54+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/"},"wordCount":114,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/","name":"Invalid attempt to GetBytes on column - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-12-24T08:27:54+00:00","description":"An error occurred while executing batch. Error message is: Invalid attempt to GetBytes on column 'xxx'. The GetBytes function can only be used on columns of type Text, NText, or Image.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/24\/invalid-attempt-to-getbytes-on-column\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Invalid attempt to GetBytes on column"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46","name":"Ekrem \u00d6nsoy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","caption":"Ekrem \u00d6nsoy"},"description":"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.","url":"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/423"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6878"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6878\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}