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?
asked
F5 in an SSRS project
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.
http://stackoverflow.com/questions/1630044/how-can-i-reassign-f5-in-visual-studio
Seems you can do it. Tools, Options, Environment, Keyboard...
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!
