We can open the containing folder from Visual Studio Solution from context menu item "Open Project Folder". But, "Open Project Folder" is not available in BIDS. I come across this nice post which shows how we can achive this functionality with help of external tool option. Below is the same setting for SSMS, by which we can open the directry where sql query file resides. Also added image on my sky drive if image is not visible. Image can be accessed from this link. Now, we can open the file folder from Tools->Open File Folder or by shortcut ( Alt+T,O, Enter). If there are any unsaved file, it will first ask to save those files and that's little annoying thing using this workaround.
We can open the containing folder from Visual Studio Solution from context menu item "Open Project Folder". But, "Open Project Folder" is not available in BIDS. I come across this nice post which shows how we can achive this functionality with help of external tool option.
Below is the same setting for SSMS, by which we can open the directry where sql query file resides.
Also added image on my sky drive if image is not visible. Image can be accessed from this link.
Now, we can open the file folder from Tools->Open File Folder or by shortcut ( Alt+T,O, Enter).
If there are any unsaved file, it will first ask to save those files and that's little annoying thing using this workaround.
Tags: SSMS
That's a good one, Chintak! Thanks for sharing!