• Looking to resolve SQL Server performance problems caused by using many temporary tables

    I need your advice on the SQL Server performance tuning. The Problem: We use a lot of temporary tables in our application, which is causing a lot of SQL Server performance problems. I read about the following solution on some site. "RamDisk presents a powerful solution to this problem by providing...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error

    My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to set up a threshold on a SQL Server 2000 Agent backup job?

    I would like advice on setting up a threshold if a SQL Server 2000 Agent backup job (nightly) is running after a certain time (7 a.m. PST), I would like to cancel it.

    SQL Server Ask the Experts2,585 pointsBadges:
  • After Unicode, SAP release strategy sequence changed

    Help, please!We recently did a Unicode conversion (SAP 4.7 from SQL 2000 to 2005, and from 32 bit O/S to 64 bit also). We now find that even though in config the release strategy has the correct sequence, when the approver views the screen (via workflow or even ME52N) to a Purchase Requisition, the...

    Jahmusical5 pointsBadges:
  • unable to modify field in SQL Server 2005

    I have a database that was working perfectly on SQL 2000. We moved the data to SQL 2005. Now when our program accessing the SQL 2005 Server we get "Field 'optional' cannot modify." The Field optional is a bit field. The program is able to modify other tables in the database. It just won't modify...

    only1rb15 pointsBadges:
  • Copy a SQL Server 2005 database into a SQL Server 2000 instance?

    Hi, Greg. After an upgrade from SQL Server 2000 to SQL Server 2005, the application team would now like to go back to SQL Server 2005 without data loss. We have built a new SQL Server 2000 instance for them, but now need to get the user databases copied over or restored. What is the best way to...

    Kmcfry45 pointsBadges:
  • Converting from 2000 to 2005

    I was given an existing application/database with stored procedures to work on. The existing database is in 2000 however the manager would like it converted to 2005 (she thought it already was a 2005 database). My system is only configured for 2005 so my analysis tools are not working on the...

    GUI Girl5 pointsBadges:
  • Check for Inserting Same ID Number using VB.NET and SQL Server 2000

    I have ID Number Based Application once i enter one ID Number how can i put a check to stop entering same ID number am using VB.Net with Sql2000

    Flyhigh5 pointsBadges:
  • Is firewall preventing SQL Server from showing up in the EM?

    I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out. When I use the MMC Snap-In from computer management, I can...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I move all stored procedures to a new SQL server?

    I recently moved a database from SQL Server 2000 to a new server running SQL Server 2005. Is it possible to move all of the stored procedures to the new server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Create Information_Schema view

    Back in 2k, there was a backdoor that allowed you to create an INFORMATION_SCHEMA view. Backdoor yeilds a permissions error in 2k5. Is there any way to create a view in Master that would be accessabile from all databases like the Information_Schema views? Thanks for the help... --Jeff Moden

    Jeff Moden30 pointsBadges:
  • How can I restore my old data into the new design in SQL Server 2000

    The SQL Server 2000 application I was using was badly designed. Now that there has been a rework of my database design, so many more tables and columns are being added. How can I restore my old data into the new design?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to transfer encrypted data between SQL Server 2005 and SQL Server 2000

    We are a retail/web/phone order store. We process credit cards for all three stores at our retail location. We have our web data stored offsite on the web server, using SQL Server 2005. We have our retail/phone order data stored onsite in SQL Server 2000. I'd like to add a function to our MS Access...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can we reindex a SQL Server 2000 database?

    We have a SQL Server 2000 database that has never been reindexed. Do you have any suggestions? Is there a link to a step-by-step process for SQL Server database reindexeing you can share?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I bring a .dat database file into SQL Server 2005?

    I need to bring a .dat database into SQL Server 2005. When I right click on database and Task, I don’t get the "Copy Database" option. What do I need to have this? What is an alternative method to bring the SQL Server 2000 database into SQL Server 2005 Express?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql 2005 db security for public

    I have databases that were converted (by restore) from sql 2000 to sql 2005. I found a script to move the logins (all using nt/sql auth) to the 2005 box. All the users on the sql 2000 box belonged to public on the old box. If i loook at the users inside the db's on the 2005 box (no public) they are...

    tcstl95 pointsBadges:
  • Connecting from VB6 to a remote Oracle Database

    We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our...

    Gcasner5 pointsBadges:
  • Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    LindaLawson10 pointsBadges:
  • Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    LindaLawson10 pointsBadges:
  • 29 Feb incorrect in DateAdd and GetDate command

    Hi, Does anyone know Why the day of date different ? when i used : select GetDate() --> It's Return 2008-02-29 11:01:45.310 and then when used : select DateAdd(yyyy,543,GetDate() ) ---> It's return 2551-02-28 11:01:45.310 My SQL Server is MS SQL Standard Edittion VERSION 6.5 Anyone have any...

    283036050 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