November 7, 2008 at 1:14 pm
I just installed Sql 2005 Reporting Services on my workstation (running sql 2005, sp2, developer edition). I read that, under Mangement Studio, I should now be able to select a database and then select the "Report" button to generate various reports about database size usage, longest running query, etc.
Unfrortunately, the Report button does not appear for in my Management Studio. Any ideas?
TIA,
barkingdog
November 7, 2008 at 1:28 pm
Are you SURE you have SP2? As best I can recall, those thing didn't show up until SP2. I'd reapply/reinstall my client tools, and then repatch the machine
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
November 7, 2008 at 1:34 pm
right-click on a Database, you'll see a "Report" menu item -> Standard Reports
November 7, 2008 at 5:04 pm
Matt Miller (11/7/2008)
Are you SURE you have SP2? As best I can recall, those thing didn't show up until SP2. I'd reapply/reinstall my client tools, and then repatch the machine
Matt, those things existed in SP1 at least - as far as I can recall. The confusing part of this was that in SP1 there was a 'Report' button available. In SP2 - the report button was removed and the Reports context-sensitive menu item was added.
Caused quite a bit of confusion - and apparently, still does...;)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 7, 2008 at 7:45 pm
Thank you everyone for your replies.
What a confusing bit of arcane stuff.
Barkingdog
November 8, 2008 at 12:07 am
Jeffrey Williams (11/7/2008)
Matt Miller (11/7/2008)
Are you SURE you have SP2? As best I can recall, those thing didn't show up until SP2. I'd reapply/reinstall my client tools, and then repatch the machineMatt, those things existed in SP1 at least - as far as I can recall. The confusing part of this was that in SP1 there was a 'Report' button available. In SP2 - the report button was removed and the Reports context-sensitive menu item was added.
Caused quite a bit of confusion - and apparently, still does...;)
Crikey...didn't realize that one. yup - ugly it is...
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply