Can I install SQL Server 2005 32 bit on 64 bit OS?
can I install SQL Server 2005 32 bit on 64 bit win 2003 OS?

Answer Question   |  February 5, 2011  5:51 AM
SQL 2005 installation, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server installation, SQL Server Installation Options, Windows Operating System, Windows Server 2003

SQL SERVER SAN Setup
I do not know much about SAN’s, I want to setup a SQL Server to use a SAN. 1. Should I use a SAN drive to install the OS or is it best practice to install the OS on a local drive on the server? 2. Should I install SQL SERVER on the SAN or on a [...]

Answer Question   |  November 15, 2010  9:15 PM
SAN, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 (32-bit)

High Disk usage on SQL Server 2005
We recently upgraded our application from version 3.1 to 3.5. We had run the latest schema and other DB changes on the existing 3.1 Database. This is how we upgrade to higher versions. Now the problem is, after the upgrade, the disk usage has gone very high. What are the possible reasons for high disk [...]

Answer Question   |  August 31, 2010  8:58 AM
Disk usage, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 Database, SQL Server 3.5 Compact Edition

Identity Reseed SQL Server 2005
I have the following table create table SubscriptionTrans ( transid bigint identity(9223372036854775805,1), transdate datetime ) Run the below insert script 3 times. insert into SubscriptionTrans select getdate() You’ll get below error Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow error converting IDENTITY to data type bigint. Arithmetic overflow occurred. Is there a way [...]

Answer Question   |  July 27, 2009  10:15 AM
SQL Server 2005, SQL Server 2005 (32-bit)

Drop Database Connections
Hi,How can I drop all connections of a database through TSQL commands.(NOT SMO)

Answer Question   |  April 13, 2009  8:12 AM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server databases, T-SQL

Can I install SQL Server 2005 32-bit on Vista 64-bit?
I have a processor of 64-bit and windows vista SP1 64-bit. But i want to install sql server 2005 32-bit does it support or can i install it on 64-bit. shekhar.parate@wipro.com

Answer Question   |  February 9, 2012  4:47 AM
64-bit processors, SQL Server 2005, SQL Server 2005 (32-bit), Windows Vista, Windows Vista 64-bit

SQL Server 64-bit Memory Requirement
We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise High availability environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. What I have a problem determining is what is a good baseline for the base memory [...]

Answer Question   |  January 29, 2009  9:54 PM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 (64-bit), SQL Server memory, SQL Server Upgrade

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.

Answer Question   |  December 2, 2008  9:16 PM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 (64-bit), SQL Server migration

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