{"id":4713,"date":"2005-10-12T09:47:00","date_gmt":"2005-10-12T09:47:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/buckh\/2005\/10\/12\/sql-error-in-get-with-beta-3\/"},"modified":"2005-10-12T09:47:00","modified_gmt":"2005-10-12T09:47:00","slug":"sql-error-in-get-with-beta-3","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/buckh\/sql-error-in-get-with-beta-3\/","title":{"rendered":"SQL error in get with beta 3"},"content":{"rendered":"

On the forum, a couple of users have run into this issue with get, so I thought I would mention it here.<\/p>\n

There’s a known issue in beta 3 where mapping a server path to a local path that exceeds the NTFS limit results in a SQL error message.  The RTM code will give you a nice message to that effect rather than the SQL error message.<\/p>\n

\n

A database error occurred (SQL error 8152) —> String or binary data would be truncated.<\/font><\/span><\/p>\n

MyServer.TFSVersionControl..prc_Get: Database Update Failure – Error 8152 executing EXECUTESQL statement for #versionedItems<\/font><\/span><\/p>\n

The statement has been terminated.<\/font><\/span><\/p>\n<\/blockquote>\n

If you run into this problem, you can fix it by editing your workspace mappings to change the local path to be shorter.<\/p>\n

For example, if you have “$\/project\/some_path” mapped to “c:documents and settingsuservisual studio projectssome_path” then change the local path to something shorter, such as “c:projectssome_path” and then run get again.  To modify your mappings in VS, use File -> Source Control -> Workspaces, select your workspace, and click Edit.<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

On the forum, a couple of users have run into this issue with get, so I thought I would mention it here. There’s a known issue in beta 3 where mapping a server path to a local path that exceeds the NTFS limit results in a SQL error message.  The RTM code will give you a nice […]<\/p>\n","protected":false},"author":94,"featured_media":10268,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[6,8],"class_list":["post-4713","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-source-control","tag-team-foundation"],"acf":[],"blog_post_summary":"

On the forum, a couple of users have run into this issue with get, so I thought I would mention it here. There’s a known issue in beta 3 where mapping a server path to a local path that exceeds the NTFS limit results in a SQL error message.  The RTM code will give you a nice […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/4713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/users\/94"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/comments?post=4713"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/4713\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/media\/10268"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/media?parent=4713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/categories?post=4713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/tags?post=4713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}