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?
Answer Question
| April 4, 2008 1:46 PM
SQL error messages, SQL Server 2000, SQL Server 2005, SQL Server migration, SQL Server performance, SQL Server upgrades
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?
Answer Question
| April 4, 2008 1:46 PM
SQL error messages, SQL Server 2000, SQL Server 2005, SQL Server migration, SQL Server performance, SQL Server upgrades
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 sequence [...]
Answer Question
| April 3, 2008 4:03 PM
Release strategy sequence, SAP, SAP upgrades, SQL Server 2000, SQL Server 2005, Unicode
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 sequence [...]
Answer Question
| April 3, 2008 4:03 PM
Release strategy sequence, SAP, SAP upgrades, SQL Server 2000, SQL Server 2005, Unicode
jobs runing on the server
hi every 1, i am having a real tough time to figure this one out . i need to find out what jobs are schedule in the server that sends data out to ever . we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another [...]
Answer Question
| May 14, 2008 3:08 AM
SQL Server 2000, SQL Server 2005, SQL Server administration, SQL Server migration
hi every 1, i am having a real tough time to figure this one out . i need to find out what jobs are schedule in the server that sends data out to ever . we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another [...]
Answer Question
| May 14, 2008 3:08 AM
SQL Server 2000, SQL Server 2005, SQL Server administration, SQL Server migration
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 existing database. The server [...]
Answer Question
| March 28, 2008 6:24 PM
SQL, SQL Server 2000, SQL Server 2005, SQL Server migration
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 existing database. The server [...]
Answer Question
| March 28, 2008 6:24 PM
SQL, SQL Server 2000, SQL Server 2005, SQL Server migration
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 [...]
Answer Question
| April 2, 2008 7:43 AM
SQL Server 2000, SQL Server 2005, SQL Server errors, SQL Server migration
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 [...]
Answer Question
| April 2, 2008 7:43 AM
SQL Server 2000, SQL Server 2005, SQL Server errors, SQL Server migration
HOw do I restore a database from a backup in MS SQL Server 2000
I have no knowledge of MS SQL Server. Have software (BOOMI) that uses a database in this. I found a folder where the database is being backed up. i.e. there is a *.BAK file and hourly logs *.TRN. I need to update the boomi software and they say I need to make a back up [...]
Answer Question
| May 14, 2008 11:46 AM
Boomi, Restore, SQL Server 2000, SQL Server backup
I have no knowledge of MS SQL Server. Have software (BOOMI) that uses a database in this. I found a folder where the database is being backed up. i.e. there is a *.BAK file and hourly logs *.TRN. I need to update the boomi software and they say I need to make a back up [...]
Answer Question
| May 14, 2008 11:46 AM
Boomi, Restore, SQL Server 2000, SQL Server backup
i want to change the true bits to false and vice versa
i have a table where i have true and false bits..i need to replace the true bits to false and vise versa
Answer Question
| May 14, 2008 6:06 AM
BIT data type, SQL Server 2000
i have a table where i have true and false bits..i need to replace the true bits to false and vise versa
Answer Question
| May 14, 2008 6:06 AM
BIT data type, SQL Server 2000
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
Answer Question
| March 24, 2008 11:23 PM
SQL Server 2000, VB.NET, Visual Basic .NET
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
Answer Question
| March 24, 2008 11:23 PM
SQL Server 2000, VB.NET, Visual Basic .NET
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 see my local SQL [...]
Answer Question
| March 24, 2008 8:45 PM
MMC, SQL Server, SQL Server 2000, SQL Server Enterprise Manager, SQL Server security
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 see my local SQL [...]
Answer Question
| March 24, 2008 8:45 PM
MMC, SQL Server, SQL Server 2000, SQL Server Enterprise Manager, SQL Server security
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?
Answer Question
| March 22, 2008 7:01 PM
SQL Server 2000, SQL Server 2005, Stored Procedures
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?
Answer Question
| March 22, 2008 7:01 PM
SQL Server 2000, SQL Server 2005, Stored Procedures
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 [...]
Answer Question
| April 1, 2008 5:03 PM
Copy programs, SQL Server 2000, SQL Server 2005
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 [...]
Answer Question
| April 1, 2008 5:03 PM
Copy programs, SQL Server 2000, SQL Server 2005
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?
Answer Question
| March 17, 2008 2:34 PM
SQL Database, SQL Server, 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?
Answer Question
| March 17, 2008 2:34 PM
SQL Database, SQL Server, SQL Server 2000
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
Answer Question
| March 17, 2008 4:30 AM
INFORMATION_SCHEMA views, SQL Server 2000, SQL Server 2005
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
Answer Question
| March 17, 2008 4:30 AM
INFORMATION_SCHEMA views, SQL Server 2000, SQL Server 2005
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 [...]
Answer Question
| March 17, 2008 10:22 PM
SQL Server 2000, SQL Server 2005, SQL Server encryption, SQL Server security, SQL Server upgrades
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 [...]
Answer Question
| March 17, 2008 10:22 PM
SQL Server 2000, SQL Server 2005, SQL Server encryption, SQL Server security, SQL Server upgrades
Setting up database mirroring for disaster recovery in SQL Server
I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, [...]
Answer Question
| March 12, 2008 10:04 PM
Database mirroring, Disaster Recovery, High Availability, SQL Server 2000, SQL Server 2005
I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, [...]
Answer Question
| March 12, 2008 10:04 PM
Database mirroring, Disaster Recovery, High Availability, SQL Server 2000, SQL Server 2005
Connectiveity JAVA to Sql server 2000
Dear all, I have problam to connect SQL 2000 server with jdbc driver. i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks
Answer Question
| March 11, 2008 6:02 AM
JDBC, SQL Server 2000, Windows Server 2003
Dear all, I have problam to connect SQL 2000 server with jdbc driver. i m using windows 2003 server SQL server 200000 and jbuilder. anyone have jdbc driver for the same environment thnaks
Answer Question
| March 11, 2008 6:02 AM
JDBC, SQL Server 2000, Windows Server 2003
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?
Answer Question
| March 7, 2008 10:29 PM
SQL Server 2000, SQL Server database design and modeling
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?
Answer Question
| March 7, 2008 10:29 PM
SQL Server 2000, SQL Server database design and modeling
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?
Answer Question
| March 7, 2008 10:26 PM
SQL Server 2000, 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?
Answer Question
| March 7, 2008 10:26 PM
SQL Server 2000, SQL Server 2005
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 [...]
Answer Question
| March 6, 2008 10:07 PM
SQL Server 2000, SQL Server 2005, SQL Server security
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 [...]
Answer Question
| March 6, 2008 10:07 PM
SQL Server 2000, SQL Server 2005, SQL Server security
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 ideas ?
Answer Question
| February 29, 2008 4:53 AM
SQL Server 2000, SQL Server development
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 ideas ?
Answer Question
| February 29, 2008 4:53 AM
SQL Server 2000, SQL Server development
