x

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

avatar image

Rob Farley
5.8k 16 21 28

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

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

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

more ▼

answered Oct 27, 2009 at 08:08 AM

avatar image

Rob Farley
5.8k 16 21 28

(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

avatar image

Kev Riley ♦♦
63.8k 48 61 81

(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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x152
x39
x5

asked: Oct 27, 2009 at 05:34 AM

Seen: 2590 times

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

Copyright 2016 Redgate Software. Privacy Policy