Skip to main content

Posts

Showing posts with the label SSMS

How to create MySQL Link Server in SQL Server 2012

Workbench is a free tool for MySQL but it is collection of issues in working environment. So I came back on SQL Server management studio. But think if our requirement is something like what , data will be at same place in MySQL and we have to access from SQL Server. Then we can use SQL Server's  Server object’s Link server .  Today I am going to share 7 steps how I have made linked server from SQL Server to MySQL. 

CTRL+R is not working in SSMS 2012

Now I am habituated to use CTRL+R to see the code in full screen because it allows me to hide the result or message pane from windows.  Working on SSMS for Development or testing any TSQL procedures I like too much and I am using this tool since 4 years.