• Hiding Columns in Report in SSRS

    How can I hide or show columns based on a parameter in SQL Server Reporting Services.

    Jamisoe10 pointsBadges:
  • SQL query to select highest test score

    I am writing a sql to bring someone's highest test score into a table. The sql is bringing in the highest test score possible, rather than the person's test score. I assume MAX is making that happen. If I take MAX out, it returns the single row subquery returns more than one row error. What can I...

    Cmyers40 pointsBadges:
  • Adding columns and updating a SQL table in a reporting database-

    My SQL table contains about 80 columns; it is a reporting database, so I update this table data daily from an application database. I need to add 20 more columns, but when I add for the present job, it is not completing. The present job logic is using a permanent table to get all the records at a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Two programs with separate SQL Databases

    I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?

    Cstanley25 pointsBadges:
  • Configuring a password message prompt on SQL Server 2000

    On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message while restoring the a SQL database onto a mirror database

    I took a backup of my main SQL database, and I have created a new database with the name of MirrorDB. When I tried to restore the main database with NORECOVERY, MirrorDB is constantly listed as "Recovering," and it won't stop. I am getting a message that it is in the middle of the restore and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Reducing CPU usage on a SQL Server application

    I have Windows Server 2003 and with SQL Server 2005 installed. I run my timesheet software on that SQL server, but CPU usage reaches 70% to 80% when the program is running on many consoles on the client side. Is there a solution to reduce CPU usage?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need SQL query

    Hi, I have a emp table in which I have 7 columns and hiredate is one of the columns. I need to query for the hiredate which has maximum number of employees joined the company on a particular date?

    Kirankg5 pointsBadges:
  • ReportServerService restarting after app domain cant unload

    SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. We are rs2005 Version 9.00.3239.00. What is causing this error to happen when in the ReportServerService_Main log there are 11 attempts to unload the app domain from 14:16:18 to 14:19:04 and then this error => e ERROR:...

    MJT20 pointsBadges:
  • Community Update: New Member Contest – Earn Knowledge Points and win!!

    Get some Amazon.com gift cards for your holiday shopping. Now is your chance to win an Amazon gift certificate based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. The top 10 most active...

    ITKE371,795 pointsBadges:
  • Improving the performance of a SSRS report in SQL Server 2005

    How can I improve the performance of a SQL Server Reporting Services (SSRS) report in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Testing when primary and mirror SQL Servers are the same

    My primary SQL Server and mirror SQL Server are the same. Is this allowed for testing?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Comparing views, user-defined functions and stored procedures in SQL

    How do views, user-defined functions (UDFs) and stored procedures work in SQL, and what conditions are there on their usage?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Acquiring remote access for SQL Server 2000 from a private server to a public server

    How do I acquire remote access for SQL Server 2000 from a private server to a public server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Limit admin access to a single database SQL2005

    I want to set up an account similar to sa but limit the rights to a particular db.

    Cybx10 pointsBadges:
  • shrinking of pie-chart graph when there is no data

    In my application, i have to display "No Data Available " at the pie-chart when there is no data to show in pie-chart... I have done that by setting the NoRows property to "No Data Available" , but the graph block shrinks by 1-2 mm when there is no data..Can anyone provide me the solution to this...

    Bhushanladdad30 pointsBadges:
  • SQL Server restore duration

    what DMV show restore info. including the duration of a restore?

    JDPhillips5 pointsBadges:
  • Exchange 2000 and Active Directory mess

    I inherited the bulk of these problems due to poor forethought by a previous consultant. He moves on server crashes I get called in with no real history or information, workarounds to get business critical apps going while waiting on parts for other server and now stuck in the quagmire I'm in....

    Injury5 pointsBadges:
  • Migrate FROM SQL2005 Ent. TO SQL2005 Standard

    We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to do...

    Jtncat5 pointsBadges:
  • SQL Server 2000

    How do I connect my AS/400 to a SQL Server 2000

    Jld10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.