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?

more ▼

asked Oct 27, 2009 at 05:34 AM in Default

Rob Farley gravatar image

Rob Farley
5.7k 16 18 20

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.
Aug 10, 2010 at 05:10 AM GPO
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first


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

more ▼

answered Oct 27, 2009 at 08:08 AM

Rob Farley gravatar image

Rob Farley
5.7k 16 18 20

(comments are locked)
10|1200 characters needed characters left

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!

more ▼

answered Oct 27, 2009 at 06:29 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.8k 47 49 76

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, 2009 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, 2009 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, 2009 at 08:55 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 27, 2009 at 05:34 AM

Seen: 1975 times

Last Updated: Oct 27, 2009 at 05:34 AM