I want someone to be able to execute a DTS Package but I do not want to give them access to Enterprise Manager. Is there anywhere way of doing this. Like a shortcut on their desktop. Thanks in adavnce for help.
View 1 Replieshello friends..
i am a new user to sql,
i was wondering if anyone here will help me to get all the keyboard shortcuts while working on sql...
thankyou
Hi,
I have a relatively common scenario. There is a stored procedure which takes two input parameters which are used as clauses in the query, e.g:
select * from myTable where (field1 = @param1 or field2 = @param2)
Now, the behaviour I'm ideally looking for is for the SP to implement different logic depending on what parameters have been supplied. If either one of the params has a value of zero then I want to run the query on the other param only, or if both params have values greater than zero, then I want to run the query using both parameters e.g.:
pseudocode:
If @param1 = 0 then
select * from myTable where field2 = @param2
else if @param2 = 0 then
select * from myTable where field1 = @param1
else if param2 <> 0 and param1 <> 0 then
select * from myTable where field1 = @param1 and field2 = @param2
Looks straightforward enough. In reality of course the actual query is much more complicated than that, and it's a mess to write it out three times just to do a bit of if/else logic.
There are two obvious solutions to this: either do the if/else in code and call different SPs, or make the query an SP on its own which is called by my original SP with different logic. For various reasons I'd rather not do either of these things.
This is such a common scenario that I'm wondering whether or not there's some easier, cleaner solution that I've missed, or don't know about. Is there?
Cheers,
Matt
I have been using SSRS2k5 now since early CTP, and one thing that bothers me is the lack of keyboard shortcuts and windows standards.
For example: If I am in the data screen, and want to enter a SQL Query, I cannot use the tab key. So I copy it to SQL Management Studio, but I cant use CTRL-A to select all.
If I am in the layout tab, and want to bold a field, I hit CTRL-B, but that pulls up the breakpoint entry dialog.
If I have a table on a report, and want to add click-thru navigation, I have to:
Right click on cell 1
Click on properties
Select Navigation
Click on Jump to Report
Select the report from the list
Click on parameters
Select parameter 1
Now, if I want a field as the parameter, i can just select from the drop down, but most of the time I am passing parameters from the 1st report to the 2nd report. Then i have to:
Click on the Expression button
Either type the parameter name, or click on it from the list.
Press OK
Repeat number 8 for the number of parameters.
Hit OK.
Hit OK.
REPEAT FOR ALL CELLS
Now, here is the issue... If you have a 20 column table, and have similar click thru functionality, you have to repeat this process for each cell. You cannot multi select. THAT would be a huge timesaver. I would rather set all 20 cells the same, and tweak 1 or 2, rather than kill my wrist mousing thru the above process 20 times. (It hurts, trust me )
These seem like little things, until you are working on 50 reports in a short time frame.
Anyone else find this bothersome?
Is there any improvement on the GUI in the next release?
Thanks!
BobP
Hello. Does anybody knows if the are shortcuts to differrent menu items in Sql 2005 Management Studio ?For example i will to use the "Execute " button without need to use the mouse, as this case as of others.Any knows where can i find a map or a page info with the shortcuts of SQL2005 Management Studio ? Thanks
View 1 Replies View RelatedHi,
I want to tell to user about SQL Server Configuration Manager and wants to allow him "START / PAUSE / STOP" for SQL Server Express in system Tray. It is easy for the end user who don't know SQL Server.
Thanks
Hy everybody.
I have recently installed from scratch RS 2003 on a WIN2003 SRV and got that the problem that the administrator cannot access or even see the regular administration toolbar and links at the Report Manager, such as Site Configuration, Upload New File, the common 'Contents | Properties ' tab, among other stuff. The only options available are 'Home', 'My Subscriptions' and 'Help', in the right superior link bar. I find this behaviour very strange, since the RS comes right out of the box configured with full access to administrator, but right now I CAN'T do any administration task on the RS Server.
Another strange behaviours I've found:
- The few links that appear redirect to the internal ip address of the server.
- When you call the '/ReportServer/ReportingService.asmx' it returns an XML document, not the usual browsing interface.
There's some information about the server configuration I think it might help:
- IIS is running more than one website, and the RS server is not installed on the Default WebSite, wich is stopped.
- SharePoint Services is running in the server, but not in the DefaultWebSite.
- The security settings of the virtual directory of the Report Manager are configured to use Windows Authentication and are NOT configured to use anonymous authentication.
- The server is published to the Internet.
There's some stuff that I tried and for now didn't worked:
- Create the virtual directories in other websites.
- Switch the attributes of the 'impersonate' attribute in Web.config file between true and false.
- Enable anonymous authentication and use the administrator account to impersonate.
- The steps described in the help article 'Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services'
- Reinstalling the RS product.
I really hope you guys can help me with this.
Thanks in advance.
JC