• SSRS Memory Performance

    Microsoft SQL Server Reporting Services Version 9.00.3239.00 We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions...

    MJT20 pointsBadges:
  • Reading the content of a URL into a table in SQL Server 2005 Express

    I need to insert the contents of httplog (which is basically http://xx.xx.xx.xx/httplog) into a table in SQL Server 2005 Express. How can I do this? Can I read the contents of httplog directly into the table (with a varchar 1000), or I need to use third party software?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi

    Hi, I am new to Database Technology and was asked to upgrade from MS SQL Server 2000 to 2005. I followed the procedure regarding the upgration found in one of the posts.THe Upgrade advisor says "SQL Server 2000 DTS Designer components are required to edit DTS packages" and In how to resolve this we...

    Psweta435 pointsBadges:
  • Backing up and upgrading a SQL Server 2000 database

    We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to enable a trace for SQL Server Analysis Services using T-SQL?

    Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do this in T-sql like an SP or a...

    GIG240 pointsBadges:
  • How to import Microsoft Access to SQL Server 2005

    hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa

    Deepatss5 pointsBadges:
  • SQL 2005 32 bit – SQL 2005 64 bit

    Moving from SQL 2005 32 bit - SQL 2005 64 bit. What are the problems which can be faced during this move.

    Vani175 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:
  • 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:
  • 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:
  • 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:
  • Log shipping after upgrading to SQL Server 2005

    I've upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using the snapshot feature in SQL Server 2005 to replicate an operational database

    We are trying to keep a replicated copy of a customer’s operational database at our hosting facility. Our copy of their operational system will be used to run ETL against each night to refresh a data reporting database. Our hope is that, each night, we will receive a snapshot file and apply that...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error messaging while using BCP in SQL Server 2005

    I am getting this error while using the Bulk Copy Program (version 9.0) in SQL Server 2005: "An error occured while processing the command line". I am using the following command: bcp MyDatabase..temptable in "C:Documents and Settings\RishiOut.txt" -c -r n -SMyServer -UHamp -Ppass123...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backing up SQL Server 2005

    Where can I find information on backing up SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SSIS package

    I am supposed to Run an sproc /script for more than one database. I thought of scheduling this sproc as a job for all database instances. But, DBA's suggested me to go with SSIS Package. Can any one quide me in doing this.

    MSDEVELOPER5 pointsBadges:
  • sql server stored proc question

    Hi the code is like this. Its taking too long to excute. if exists(select jbadsd from saldayf sa where substring(convert(char(7),sa.jbadsd),4,4) = substring(convert(char(7),@jbadsd),4,4) and substring(convert(char(7),sa.jbadsd),2,2) = '07') --print'exists' update [national].dbo.tempsaldayfna set...

    Gullu15 pointsBadges:
  • How can I connect my local machine to the SQL Server 2005 Enterprise Edition?

    How can I connect my local machine to the SQL Server 2005 Enterprise Edition?? I can't even run the local service instance

    Jimena8a5 pointsBadges:
  • Differences between values in a SQL Server 2005 database

    What is the difference between the Checksum and TornPageDetection values of the PageVerify option in a SQL Server 2005 database's properties?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Strange Stored Procedure Behavior (Dev vs Prod)

    I have a stored procedure that runs on my Production database in 0.394 seconds. However, when I try to run the SP on a DEV box it takes well over 15 minutes to run *every* time. I have checked indexes and everything seems to be identical (I did a backup/restore to the Dev box in the first place)....

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