Viewing 15 posts - 31 through 45 (of 60 total)
I am not running any performance counters, but I have task manager open so I can see when the CPU spikes.
I am mostly wanting to do this so that the...
April 7, 2004 at 9:44 am
It has 2GB allocated to it and there isn't anything else using the new instance either. I bumped it up to 4GB and it didn't seem to help.
Jarret
April 7, 2004 at 8:48 am
I just tried to export a report to an Excel file and it opened in Excel 2000. Do you get an error message or something when you try to open...
March 30, 2004 at 7:00 am
I was unaware that there were different versions of RS, a co-workers of mine downloaded the version for me (turns out to be the Developer Edition). Here's the EULA displayed...
March 16, 2004 at 11:04 am
As long as the server you are going to be running RS on is licensed for SQL Server 2000, you can install RS on it at no additional cost.
It is independent...
March 16, 2004 at 8:11 am
I think there is only one version of RS. The system requirements from Microsoft say that RS will work on SQL Server 2000 Standard Edition with SP3 or later.
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
Hope...
March 16, 2004 at 7:43 am
I guess I hadn't noticed the Command type drop down box.
Once I changed that, it worked like a charm. Thanks!!!
Jarret
March 16, 2004 at 7:14 am
Sorry for the confusion, I didn't mean that temp tables don't work with RS, just that when I tried to create the report with the wizard, I got an error...
March 15, 2004 at 6:43 am
In Query Analyzer, from the Tools menu, select Options, then on the Results tab, change your options to these:
Default results target: - Results to Text
Results output format: (*) - Custom Delimiter
Delimiter: (*) - |
This should do...
March 14, 2004 at 8:34 am
The SP I first used was just a normal select, I will try it with a cursor.
I created a proc with the nested cursor from BOL under 'DECLARE CURSOR' in the pubs database. I changed all of...
March 12, 2004 at 7:01 am
I just tried creating a report by using a stored procedure as the data source and it worked for me.
In the 'Design the Query' dialog box, type EXEC rptDailyCumulativeProdSummaryByBussUnit...
March 11, 2004 at 2:54 pm
From QA, this will give you the statements that you will need to run in order to change the objects that are not owned by 'dbo' to have 'dbo' as...
March 10, 2004 at 10:03 am
I had this problem when I tried installing Reporting Services.
When I installed the eval version, I was able to continue past the component screen once I had VS.NET installed. I...
March 10, 2004 at 8:25 am
Going along with Steve's post, if you also check the boxes for 'Script database users and database roles' and 'Script SQL Server logins (Windows and SQL Server logins)', it will...
February 26, 2004 at 10:52 am
Running the NO_LOG statement eliminates your possibility for recovery to a point in time. Whenever your user runs this Backup with NO_LOG statement, you will only be able to recover...
February 17, 2004 at 8:09 am
Viewing 15 posts - 31 through 45 (of 60 total)