|
I run my queries in Management Studio with F5. Then I put them into the Dataset part of BIDS, and hit F5 to test the query, except that here, F5 runs the solution. It's not what I want, and how do I stop F5 from doing that in BIDS?
(comments are locked)
|
|
http://stackoverflow.com/questions/1630044/how-can-i-reassign-f5-in-visual-studio Seems you can do it. Tools, Options, Environment, Keyboard...
(comments are locked)
|
|
Not sure you can stop it! This is another example of where the old Enterprise Manager and Visual Studio met, and in the battle us DBAs lost out! Another area where running the query isn't possible with F5, is the Query Designer in SSMS (right click a table and choose 'Edit Top 200 rows' in SSMS 2008, right-click and choose 'Open Table' in SSMS 2005) - not that I'm advocating that as a away of writing queries you understand! Hehe, of course. I like Ctrl-E to run queries in SSMS, but I also use F5 and do find it frustrating when I switch to BIDS.
Oct 27 '09 at 07:11 AM
Rob Farley
Your point about the old and new meetings and DBAs losing out - that is exactly why I'm writing a T-SQL editor. Personally I liked the focused nature of Query Analyser - it was light-weight, fast, and helped you get the job done. For me, SSMS falls directly under the old phrase - 'Jack of all trades, and master of none.'
Oct 27 '09 at 08:23 AM
Matt Whitfield ♦♦
Matt - I felt like MS was trying to force me into a developers world, using developers tools and concepts, which was probably OK for some DBAs and DB devs, but pushed me into a world of pain! Still haven't got my head around SSIS - that is just alien. You can't write a DTS emulator for SSIS can you :) . Are you writing this editor for yourself or do you work for a tool supplier,eg RedGate?
Oct 27 '09 at 08:55 AM
Kev Riley ♦♦
(comments are locked)
|
Arrgh! This very thing happened to me to day. I was working on a "solution" that contained (seriously) thousands of rdls. Took me a while to work out what was going on because I didn't even realize I'd hit F5.