Forum Replies Created

Viewing 15 posts - 1 through 15 (of 21 total)

  • RE: Server Slow and CPU Utilization High

    Actually I set it to 1. I normally only have about a 100 users logged in on this server during the day and my transactions per second hardly go above...

  • RE: Server Slow and CPU Utilization High

    We had a similar problem with one of our Java applications that was hitting the server. Are you seeing an abnormally high number of connections opening up? I had to...

  • RE: Reporting Services Login dialog box

    Thanks maddog & aliciaw. What I ended up doing was reinstalling Reporting Services and the SP and that seemed to reslove the logon problem. I still have backward compatability challenges...

  • RE: DateTime Picker Control

    Jason that was all it took. That field is coming in from an exteranal source and is defined as a char datatype so it din't even occur to me change...

  • RE: Reporting Services Login dialog box

    Jack:

    Yes I am able to use  SSMS to manage the report server. We have Report Manager installed on a web server and that is what I am getting prompted to Logon to....

  • RE: Reporting Services Login dialog box

    JacK

         I am not the the only one manging the server but I am the only Content Manager for Reporting Services. The OS is Windows Server 2003. I am on an Intranet...

  • RE: Charting Perfmon counters

    This tool has been around for awhile but I still use it. SQLH2 uses Reporting Services so it helps to be familiar with that. I just export the perfmon charts to...

  • RE: Attaching AdventureWorks Fails

    Attaching the AdventureWorks database is exactly what I was sttempting to do when I got the error. When I have done this in the past, like you, it worked just fine. It might...

  • RE: Printing Labels using Reporting Services

    Jim it looks like you have figured out a great solution. We are not currently using Reporting Services to print labels for some of the reasons that you mention on your...

  • RE: Rewritng a delete statement

    Farrell:

     

            I did have to tweek your suggestion for better syntax and clarification just a bit and when I reran it in my test environment it worked even much faster...

  • RE: Help me... i need to reload my cluster server running SQL Server 2000!!!

    GG:

          You'll need to begin by scripting out all your tables, views, stored procedures, DTS packages, etc.  Look at Books OnLiine and other sources about recreating users and passwords. Decide whether you...

  • RE: ODBC Connection Fail

    Tobias:

            While working in a Finance department I was able use Excel pivot tables fairly easily when the datasource was ACCESS or SQL Server. You said that perhaps 'Excel cannot...

  • RE: Migrating Oracle corrupted tables

    Silaphet:

            I have used the functionality available in DTS to do a lot of data cleanup during a migration, such as trimming spaces, case conversion, etc. We did have to...

  • RE: Exporting to Excel

    Oh never mind! After reading Thomas' post on the 'row footer' thread I realized I must have done somehting bogus when I tried using DISTINCTCOUNT and wasn't getting a correct...

  • RE: restoring the database or attachinf the datafile

    I have done this several times by copying the BAK file to the new server and using the MOVE option. From BOL:

    MOVE 'logical_file_name' TO 'operating_system_file_name'

    Specifies that the given logical_file_name...

Viewing 15 posts - 1 through 15 (of 21 total)