question

Rob Farley avatar image
Rob Farley asked

F5 in an SSRS project

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?

ssmsbidsshortcut-key
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Rob Farley avatar image
Rob Farley answered

http://stackoverflow.com/questions/1630044/how-can-i-reassign-f5-in-visual-studio

Seems you can do it. Tools, Options, Environment, Keyboard...

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

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!

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.