I have a database diagram. SSMS will let me save it. It won't let me save it as... How can I find out where SSMS has saved my diagram file?
View Complete Post
Save Coding Time, Manage Compressed Files, and More
MSDN Magazine January 2007
i need ur help in asp.net.i want to know how can i read and save data in word doc file from web page. problem domain is that i have entered data in the text boxes and saving data in SQL database. i want to save data in doc and excel file also..guide me and help me how can i do this
I'm pretty sure this almost equal to some question I already read here but did not solved my problem.
Here we go... I'm currently working on a Windows Server 2008 R2 with SQL Server 2008 and SQL Server Management Studio istalled.
When working in Visual Studio with database solution with lot of .sql files I used to double-click on the .sql files and they were opened in the same SSMS instance (if any already opened). Due to a OS error I formatted and reconfigured everything again but
now I'm getting a new SSMS instance when double clicking in each sql file. Its really painful one .sql - one SSMS instance so I started my research about that.
What I've tried till now:
1) Right click on the .sql file > "Open With" option > "Add" option > "Program Name: C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" and "Friendly Name: SQL" > "Ok"
> "Set as Default". Does NOT work. Still having one sql - one ssms instance.
2) Perfomed Run > regedit > and modify the value data of HKEY_CLASSES_ROOT\sqlwb.sql.9.0\Shell\Open\Command and replace /dde with "%1". DOES NOT WORK
3) Right click on the .sql file > "Open With" option > "Add" option > "Programe Name: explorer.exe" and "Fri