• Migrating from SQL Server 2000 to SQL Server 2005 on DTS packages

    Could someone help me with a SQL Server 2000 migration to SQL Server 2005 on DTS packages? I have a Dynamics GP integration that uses the DTS package, but I don't know SQL or DTS packages well enough.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Writing a report drawing information from a SQL Server 2005 table

    I am writing a simple report that displays records from our customer table, a table that has no corresponding records in our contacts table. My code entered in SQL Server 2005 is as follows: select contractor.name,acctstatus, statusDetail, sales_person, loggedInBy,loginDate, lastUpdateBy,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • EMC Network Backup Client/Agent backup for SQL 2000/2005 databases on Polyserve Matrix

    Hi, I am new with running SQL 2000/2005 instances on Polyserve Matrix servers. We use EMC Network as a corporate backup strategy. Can someone tell me will there be any problems using this backup tool for SQL instances on the Polyserve Matrix?

    Davidvoo5 pointsBadges:
  • Can’t manually enter data any more; get Error Message: String or binary data would be truncated.

    Three databases that were forced restored now do nor allow manual entry, even one single character, although using an update statement works. This is not a matter of changing the length of the datatype, but something else. For the life of me, I can't figure out why this mere attempt at manual data...

    Jimruddy5 pointsBadges:
  • Trouble with SQL Server 2005 Upgrade Advisor when trying to detect an instance

    I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when going to the pull-down menu, nor does it recognize it when I key in the instance name. We are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 Upgrade Advisor in a cluster/SAN environment

    I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when I go to the pull-down, nor does it recognize it when I key in the instance name. We are running on a...

    Trig15 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Moving a database from SQL Server 2000 to SQL Server 2005 and back again

    I moved my database from SQL Server 2000 to SQL Server 2005, but now, if possible, I'd like to move it back. When I open SQL Server Management Studio 2005 and check my database's properties, its compatibility is "SQL Server 2000(8.0)". Can I move my database back to SQL Server 2000, and if so, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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:
  • cluster

    what's the steps to use ( Clustering ) in any SQL Server 2005 System??

    ScorpionSQL10 pointsBadges:
  • Backing up and copying a database across SQL Servers

    I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go about doing this?

    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:
  • 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:

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.

Following