Forum Replies Created

Viewing 15 posts - 31 through 45 (of 60 total)

  • RE: Moving DB to another instance on the same server

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

  • RE: Moving DB to another instance on the same server

    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

  • RE: Export to Excel 2000

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

  • RE: Edition of RS/SQLServer2k

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

  • RE: Edition of RS/SQLServer2k

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

  • RE: Edition of RS/SQLServer2k

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

  • RE: sproc problemmmm

    I guess I hadn't noticed the Command type drop down box.

    Once I changed that, it worked like a charm.  Thanks!!!

    Jarret

  • RE: sproc problemmmm

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

  • RE: Modifying SQL Query

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

  • RE: sproc problemmmm

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

  • RE: sproc problemmmm

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

  • RE: using sp_changeobjectowner for multiple objects

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

  • RE: RSEVAL Install Problem (Server Components not available)

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

  • RE: Transfer permissions

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

  • RE: Can With NO_LOG option hurt recovery process?

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

Viewing 15 posts - 31 through 45 (of 60 total)