17 November 2015

Re-assign F5 key to refresh action in SQL Server 2014 Management Studio

- Open Management Studio
- Go to Tools >> Options
- Expand Environment >> Keyboard >> Keyboard
- In the "Show commands containing:", type "View.Refresh" and here you can observe that "Shortcuts for selected command:" will be grayed out
- Now choose "Global" in the "Use new shortcut in:" and press F5 button in "Press shortcut keys:"
- Click Assign
- Click Ok

Via.



- per abilitare li CTRL-R per visualizzare/nascondere i risultati di una query, bisogna mappare l'azione: Window.ShowResultPane
- per il "mostra risultati query come griglia" (CTRl-D), cerca Query.ResultstoGrid

09 November 2015

Enabling GodMode for Windows 10

Create a new folder and rename it in:
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

Via.

05 November 2015

Server ‘SERVERNAME1′ is not configured for RPC for a Linked Server

Da lanciare sul "client" (dove ho creato il linked server)!

To re-enable the RCP commands for the linked server:
-- CTRL-SHIFT-M per impostare i parametri :)
EXEC sp_serveroption @server='<Nome del Linked Server,,>', @optname='rpc', @optvalue='true'
EXEC sp_serveroption @server='<Nome del Linked Server,,>', @optname='rpc out', @optvalue='true'



Via.