- 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
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:
Via.
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.
Subscribe to:
Posts (Atom)