Red Gate forums :: View topic - Savint Option Sets on Win7 64 bit
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

Savint Option Sets on Win7 64 bit

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tgoldstein@co.arapahoe



Joined: 16 Oct 2006
Posts: 52

PostPosted: Wed Sep 01, 2010 4:43 pm    Post subject: Savint Option Sets on Win7 64 bit Reply with quote

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
Back to top
View user's profile Send private message
tgoldstein@co.arapahoe



Joined: 16 Oct 2006
Posts: 52

PostPosted: Thu Sep 02, 2010 4:00 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Thu Sep 02, 2010 6:04 pm    Post subject: Reply with quote

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)?
Back to top
View user's profile Send private message
tgoldstein@co.arapahoe



Joined: 16 Oct 2006
Posts: 52

PostPosted: Thu Sep 02, 2010 7:13 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
maassql



Joined: 24 Mar 2010
Posts: 4

PostPosted: Wed Sep 15, 2010 7:22 pm    Post subject: options sets not saving - windows server 2003 R2 stndrd x64 Reply with quote

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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Mon Sep 20, 2010 8:21 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
maassql



Joined: 24 Mar 2010
Posts: 4

PostPosted: Tue Sep 21, 2010 1:23 am    Post subject: Reply with quote

@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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Tue Sep 21, 2010 12:14 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Thu Sep 23, 2010 11:55 am    Post subject: Reply with quote

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!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group