SQL Server 2008 Upgrade
I have 7 SQL Servers I need to upgrade from SQL Server 2005 to SQL Server 2008. Can I install the SQL Server 2008 prerequisites using Microsoft System Center? If yes how?

Answer Question   |  February 1, 2011  8:10 PM
SQL 2008, SQL Server 2005 upgrades, SQL Server 2008, SQL Server 2008 administration, SQL Server upgrades

Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard
I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it’s shows not avalable. Kindly help how can I will get all [...]

Answer Question   |  November 1, 2010  6:18 AM
SQL Server, SQL Server 2005 Standard Edition, SQL Server administration, SQL Server Express 2005, SQL Server Upgradation, SQL Server upgrades

Process ID 174:102 owns resources that are blocking processes on Scheduler 2.
Looking for solution to Process ID 174:102 owns resources that are blocking processes on Scheduler 2. We recently installed our Lucent Vitalnet app with SQL 2000.  it runs fine for 2-3 days, then the app stops when the above SQL error message occurs.  Rebooting the server temporarily fixes the problem until another 2 days. Also [...]

Answer Question   |  September 10, 2010  4:15 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Server 2005, SQL Server upgrades, Windows, Windows Server, Windows Server 2003, Windows Server 2003 SP2

SQL 2000 Upgrade
I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?

Answer Question   |  May 29, 2009  4:23 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2005

SQL Server Table and View Index
Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

Answer Question   |  April 28, 2009  9:29 AM
Index Scan, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server upgrades, SQL Server views

Looking for detailed synchronization logging in SQL Server 2008
We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the detailed, timestamped [...]

Answer Question   |  March 21, 2009  2:57 PM
SQL Server 2000, SQL Server 2008, SQL Server replication, SQL Server synchronization, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2008

SQL Server 2005 SP3 installation on Vista – error message
A user recently submitted this question via e-mail: This Program has known compatibility issues. Check Online to see if solutions are available from the Microsoft website. If solutions are found, Windows will automatically display a website that lists steps you can take. Program: Visual Studio 2005 Publisher: Microsoft Visual Studio 2005 has a known compatibility [...]

Answer Question   |  March 17, 2009  7:25 PM
SQL Server 2005, SQL Server 2005 SP3, SQL Server on Vista, SQL Server upgrades, Vista

What are basic differences between SQL Server 2000 and 2005?
What are basic differences between SQL Server 2000 and 2005?

Answer Question   |  January 25, 2012  9:40 AM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

What Is Your SQL Server 2008 Adoption Rate?
http://benchmarkitconsulting.com/colin-stasiuk/2009/02/19/please-vote-what-is-your-sql-server-2008-adoption-rate/ SQL Server 2008 RTM is over 6 months old now and I’m wondering what people are seeing so far in terms of adoption rate. What I’ve seen so far in the environments that I’ve been working on definitely falls in the 1% – 25% category. What has everyone seen in the environments that they [...]

Answer Question   |  February 19, 2009  8:47 PM
SQL Server 2008, SQL Server 2008 Adoption, SQL Server upgrades

Upgrading to a 64-bit SQL Server 2005 environment
We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise Edition environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. The only issue we are having is determining a good baseline for the base memory to install. [...]

Answer Question   |  March 5, 2009  6:28 PM
SQL Server 2005 (64-bit), SQL Server memory, SQL Server upgrades

SQL SERVER 2000, 2005 & 2008
Can Sql Server 2000/2005/2008 exist on the same machine

Answer Question   |  January 23, 2009  4:15 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server upgrades

Upgrading to SQL Server 2005
I have a question regarding SQL Server upgrades. We have two active/passive clusters on which SQL Server 2000 resides. I want to install SQL Server 2005. How would I go about doing this?

Answer Question   |  January 11, 2009  3:31 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

Error when updating SQL Server 2000 from SQL Server 2005
Hi, I am using sqlServer 2005 and sqlServer 2000. When i update on sqlServer2000 from sqlServer2005 then following error was occured. Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

Answer Question   |  December 13, 2008  12:07 PM
DBCC CHECKDB, SQL Server 2000, SQL Server 2000 interoperability, SQL Server 2005, SQL Server 2005 interoperability, SQL Server error messages, SQL Server upgrades

Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?
What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?

Answer Question   |  December 12, 2008  8:15 AM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server 2008 performance, SQL Server migration, SQL Server performance, SQL Server upgrades

Uninstalling a SQL Server service pack
If we have problems after installing a SQL Server service pack, can we uninstall it with no issues?

Answer Question   |  December 11, 2008  7:47 PM
Service packs, SQL Server, SQL Server Service Packs, SQL Server upgrades

Estimated cost for upgrade from SQL Server 2005 SE to SQL Server 2005 EE
What is the estimated cost to upgrade from Microsoft SQL Server 2005 Standard Edition to Microsoft SQL Server 2005 Enterprise Edition?

Answer Question   |  December 10, 2008  9:06 PM
SQL Server 2005, SQL Server upgrades

Figuring out the SA password in order to upgrade to SQL Server 2005
I am upgrading my firm’s legal software to a version that uses SQL Server 2005. We are on a Windows 2003 Small Business Server, and SQL Server was installed before I started at this firm. My new software needs me to login as the System Administrator. I cannot seem to do that, as I do [...]

Answer Question   |  December 24, 2008  6:38 PM
SBS 2003, Small Business Server 2003, SQL Server 2005, SQL Server administration, SQL Server upgrades, System administrator

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?

Answer Question   |  December 2, 2008  2:51 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server database, SQL Server upgrades

Upgrade SQL Server 2005 32-bit to SQL Server 2005 64 bit
Hi, We have one development server which is running on sql 2005 32 bit contains Databases ( including Tables, SPs, views, assemblies..etc) Applications ( .net 2.0 web application, crystal reports..etc) Note: now this databases & application is under development stage. But our plan is in future we need install SQL 2005 64 bit on QA [...]

Answer Question   |  November 28, 2008  6:51 AM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 (64-bit), SQL Server 2005 32-bit to 64-bit upgrade, SQL Server 2005 upgrades, SQL Server upgrades

Executing DTSX from VB.NET 2003
We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we [...]

Answer Question   |  December 16, 2008  8:26 PM
DTS, DTS packages, DTSX, Excel import/export, Microsoft Excel, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB.NET 2003