0

I am attempting to save a .sql file from Sql Server Management Studio to a non-default directory location. I would like to be able to copy the directory path from an open Explorer window and paste it into the Save File As dialogue box. However, from SSMS, it appears the only option is to navigate to the desired folder through the GUI. Even selecting the Save in: dropdown and beginning to type just activates the GUI & associated hotkeys.

In other applications ( Excel for example ), it is possible to type or copy-paste a full directory path. Is this a setting I can toggle in SSMS?

I am not trying to change the default save location. I am attempting to speed up folder navigation when saving files from SSMS.

Is it possible to get the Save As ( Excel ) style box rather than the Save File As style dialogue box in SSMS?

Ssms Save File As dialogue ( bad )

http://i.imgur.com/8RjES5c.png

Excel Save As dialogue ( good )

http://i.imgur.com/Kq4MBk3.png

Improve this question
3
  • the application has to support the new Vista style dialogs. Now all do this. Which Sql Server Management Studio version do you use?
    – magicandre1981
    Commented Jul 14, 2015 at 15:49
  • @magicandre1981 - I use SSMS 2008 R2. Do I need to upgrade to a more recent version to get this functionality?
    – Peter Vandivier
    Commented Jul 14, 2015 at 16:13
  • @magicandre1981 I have just verified with another user in my office that SSMS 2012 provides this functionality. Thank you.
    – Peter Vandivier
    Commented Jul 14, 2015 at 16:20

1 Answer 1

Reset to default
1

The Excel SaveAs Dialog uses the new Vista style dialogs. The applications has to implement the new dialogs to support it. In your cause it must support IFileSaveDialog which seams not to be done by your older version. Update to the most recent version.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .