Is it the active/passive mode SQL Server  clustering cannot be installed on
Windows 2003 Server Standard Version?
The clustering is only available in Windows 2003 Server Enterprise Version
or DC Version?

I am attemtping to install Service Pack 2 for SQL Server 2005 on a computer
running Windows XP (SP2).
An error occurs and I get the following message in the summary file:
-----------------------------------------------

I have an application that attempts to access the TOTALS table.  
The user the application is logging into SQL 2005 as is the dbo.  The default schema of this user is dbo.
The TOTALS table is called user1.TOTALS.
The application is not able to find TOTALS - it is connecting to dbo ...

I am having problems with this and just can't figure it out. I have a
login on SQL (a windows account called TEST\sunprocess which I want to
map to a user on a database (called SunProcess). I have tried the
following:

Why is my SQL 2005 Express SO SLOW when browsing to select file for new
connection.  The screen really hangs.
Thanks, D.

For sample sake lets say I have an auto parts store and I have this
OrderItems table that I use to track each orders items. I want to see how
many matching orders I have and matching items I have. I've created this
sample sql here and I almost have the answer I need but I'm ...

I am getting this error very frequently in the Event viewer:
"The server will drop the connection, because the client driver has sent
multiple requests while the session is in single-user mode. This error
occurs when a client sends a request to reset the connection while there

Hello, I'm having problems with SQL Server 2005 Standard for Itanium systems.
I have a Partitionable Machine with 4 IA2 64Bits CPUs (it is 8 cores), but
when I try to set the Processor Affinity to 6 of the CPUs, it gives me the
following message:  "The affinity mask specified is ...

I'm using a linked server in SQL 2005 to retrieve data from Active Directory
using ADSI.  I can successfully retrieve data using the following query:
select *
from openquery

Link Server from 2000 to 2005
Is it possible to create link server from SQL Server 2000 to SQL Server 2005?

I have an application that attempts to access the TOTALS table.  
The user the application is logging into SQL 2005 as is the dbo.  The default schema of this user is dbo.
The TOTALS table is called user1.TOTALS.
The application is not able to find TOTALS - it is connecting to dbo ...

In 2005, if you use the Management Studio and import data from a csv file,
it seems to ignore the Quoted strings that have ","s in them and splits them
into 2 or more fields and of course gets an error and stops.
There doesn't seem to be a place to specify using the quotes and I ...

I am working on SQL query and am having trouble combining the
different pieces of syntax that I need.  I need to give my column as
alias but I also need to close a paratheses that will appear to the
user on the screen.

We're going to be upgrading our in place SQL 2000 server to 2005 and I was
wondering if anyone could post up any gotchas or things to look out for?  
Thanks!!

SQL Server 2005
I understand database roles.  I *thoght* I understood Schemas in 2005.  I
just noticed that there is a db_datareader schema and a db_datareader
database role in one of my user databases.  The schema of db_datareader