Savint Option Sets on Win7 64 bit

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Savint Option Sets on Win7 64 bit

Postby tgoldstein@co.arapahoe » Wed Sep 01, 2010 4:43 pm

On my Win 7 64 bit box when I try to save an option set it never appears in the folder that is listed in Option Set Location. Plus it never appears in the Saved Option Set box.

When I do exactly the same thing on an XP 32 bit box it works perfectly.

Is this a bug or is there an alternate process for a Win 7 64 bit box?

I am running build 1.5.1.83 on the XP box, but am still on the 1.3 build on the Win 7 box. Any possibility this is fixed in the new build?

Tim Goldstein
Denver, CO
tgoldstein@co.arapahoe
 
Posts: 52
Joined: Mon Oct 16, 2006 5:50 pm

Postby tgoldstein@co.arapahoe » Thu Sep 02, 2010 4:00 pm

Hate to reply to my own thread, but...
I put the cummulative patch on the Win 7 64 bit box and same issue. The option sets do not save to the folder that is specified in the location box.

Definitely a bug.

Does anyone from Red Gate monitor this section of the forum???

Tim Goldstein
Denver, CO
tgoldstein@co.arapahoe
 
Posts: 52
Joined: Mon Oct 16, 2006 5:50 pm

Postby chriskelly » Thu Sep 02, 2010 6:04 pm

I have some questions for you:

- When you make changes do you change the Options Set name? By default this is SQL Refactor defaults, which does not get saved into the directory as a new file.
- Does your user account have FULL Control permissions to the directory (Right-click Properties->Options->Sharing)?
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby tgoldstein@co.arapahoe » Thu Sep 02, 2010 7:13 pm

Yes, I am changing the name of the option set when I try to save it. As I said, it is working properly on the XP box I am using at my client and I am using the identical process to attempt to save.

Not sure on the permissions. Will check when I am back to my Win 7 64 box.

I did make the assumption that because the installer created the directory it would have proper permissions as it was run under the same admin login I work from.

Tim Goldstein
Denver, CO
tgoldstein@co.arapahoe
 
Posts: 52
Joined: Mon Oct 16, 2006 5:50 pm

options sets not saving - windows server 2003 R2 stndrd x64

Postby maassql » Wed Sep 15, 2010 7:22 pm

options sets not saving - windows server 2003 R2 stndrd x64

* "* Customized" not going away
* no error message
* not appearing in SQL Refactor Defaults
* Changing "Options set location" does not fix problem
* running ssms w/o restricted access does not fix the problem ( right click, run as )
* Sql Refactor 1.3.0.207
* check for updates - none available
maassql
 
Posts: 4
Joined: Wed Mar 24, 2010 6:29 pm

Postby chriskelly » Mon Sep 20, 2010 8:21 pm

Tim - have you been able to look at the permissions on the directory?

maassql - Thank you for your post. Have you changed the name in the 'Current Options Set' field? You cannot save to the SQL Refactor Defaults option set. Try saving under a new name.
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby maassql » Tue Sep 21, 2010 1:23 am

@chrisk5 - appreciate the attention. Yes, I've changed the name.

I submitted a support request and received a reply that the problem was somewhat reproducible and has been bugged.

Upgrading to SQL Prompt 5 was the workaround.
maassql
 
Posts: 4
Joined: Wed Mar 24, 2010 6:29 pm

Postby chriskelly » Tue Sep 21, 2010 12:14 pm

Thank you for your reply @maassql.

Tim, if you have checked the permissions/sharing on the directory and everything checks out then I believe that the same resolution applies to you. SQL Prompt 5 should be the solution.
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby james.billings » Thu Sep 23, 2010 11:55 am

Just as an update, in some testing we narrowed this down to the version of Management Studio. Tested two machines, both Win7 x64.

SQL 2008 - seems to work
SQL 2005 - doesn't.

So if you find it not working in 2008 let us know, there may be other things that can be checked!
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests