Filename length using windows xp and windows 7

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Filename length using windows xp and windows 7

Postby niall_l » Tue Dec 03, 2013 3:02 pm

We are looking at using your product for source control using git.

I have linked a database to a git working folder, and committed the objects on a Windows 7 machine with SSMS 2008 R2. Some of the unit test sprocs have quite long verbose names, with the longest path being 186 chars (filename is 134). All of these were committed fine. We use local dev VM's running Windows XP SP3 (low footprint) with SQL Server 2008 R2 Express Advanced. I installed source control 3.9 on here too, and linked the database to a clone of the repository. When I try and get the latest I get the following error message:
The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

The longest path for the VM is shorter at 175 chars, way below the limits in the error message.

Having done some investigation, i can use any path length on the XP VM as long as the filename part does not exceed 114 characters. Is this a know issue when using the product with Windows XP?

Thanks
Niall
niall_l
 
Posts: 1
Joined: Tue Dec 03, 2013 2:06 pm

Postby Manfred.Castro » Thu Dec 05, 2013 8:27 pm

I suspect you are getting different results in XP vs. 7 because of the difference in the location of where the two operating systems store local app data.
XP: \\Documents and Settings\\$USER$\\Local Settings
7: \\Users\\$USER$\\AppData\\Local
http://social.technet.microsoft.com/wik ... vista.aspx

This would explain why the specified path, file name, or both are too long in XP and not 7 because the XP path will be slightly longer than that of 7.
For the error "The specified path, file name, or both are too long".
We recommend you relocate your working base folder
http://documentation.red-gate.com/displ ... e+too+long
Note: The working base folder is different from the working folder.
http://documentation.red-gate.com/displ ... rking+base
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron