tags:

views:

33

answers:

2
+2  Q: 

In Visual Studio, change the keyboard to use an F key for "execute sql"

In Visual Studio 2010, I have a Database Project. I can use this without issue to view, edit, create sprocs, etc.

How can I change the keyboard to allow me to use an F key for "execute sql" as I would use F5 in MSSMS. I can't seem to find the right binding sequence in Tools-Options-Keyboards and figured it would be faster to ask the community, so I can focus on writing code atm.

Much obliged. (And yes, I admit I'm being lazy, but my googlefu has given up the ghost this morning and I'm just curious, it's not stopping me)

A: 

Tools>Options > Keyboard > QueryDesigner.ExecuteSQL > Create new short Cut

roviuser  2010-07-29 16:14:33
Ok, what's the trick? I'm not getting my new keyboard shortcuts to cause that command to kick off.I've tried assigning it to a global F3 (because I don't ever use it, even though I know what it is for) after I removed that from Find Again and I know there's nothing else associated to it. It's still not executing. ~ Thoughts ideas?
drachenstern  2010-07-29 16:41:56
@drachenstern you say that you're able to view, edit, create sprocs, etc. are you actually able to execute? I mean in some way other than a keyboard shortcut? MSDN has this: http://msdn.microsoft.com/en-us/library/yea4bc1b(vs.80).aspx
roviuser  2010-07-29 17:58:29
Yes I can run the scripts if I click the button on the toolbar. I can also run the scripts by going to the Data menu and clicking Transact-Sql Editor, then Execute SQL. I just want to assign it to a keystroke. Something tells me I'm missing something really obvious.
drachenstern  2010-07-29 20:47:27
+1  A: 

I was having the same issue... I also bound F5 to QueryDesigner.ExecuteSQL. No go. Then I bound F5 to Data.SqlEditorExecuteSQL. Still no go... but then I unbound F5 from QueryDesigner.ExecuteSQL and it worked... now I can hit F5 and execute a query. I was worried there for a bit. Screenshot

Shoeless  2010-08-24 18:59:53
Cool. Trying it out.
drachenstern  2010-08-25 15:52:30

related questions

Visual Studio 2010 Database Projects: Are there any videos/tutorials or comments about the new Database Project Types?
Visual Studio 2010 Database Project does not understand Schema Names anymore?
VS 2010 Database Project Run Script Conditionally
What happened to the "Run" and "Run On" commands in Visual Studio 2010 Database Projects?
How do you actually use Visual Studio Team System database projects to version Sql Server
SQL Database Project in Visual Studio
Nontrivial incremental change deployment with Visual Studio database projects
Visual Studio For Database Professionals 2008
How to force VS2008 to "Generate Create Script to Project" to multiple files when multiple stored procedures are selected?
Using MS Team System 2008 Database Edition
Visual Studio 2008 Database project Deployment Baseline
Unable to Load Database project in VS2008
database project takes a long time to open
Timestamps during MS Build
Syncing permissions between a Database project and a database using Visual studio
Pre-Deployment in Database project
Duplicate Schema
Post build on database project
Executing scripts from a database project in visual studio
Do I need the .dat file when I place a visual studio database project under version-control
How to programmatically navigate the Schema View in Visual Studio 2008?
Anyone using "database projects" in Visual Studio?
Where is the handy designer for setting Permissions and schema diagram designer in a SQL2005 Database Project in VSTS2008 Database Edition GDR RTM?
"Show All Files" option missing in VS Database Project
How do you resolve Linked server references in SQL Database project in VS?