On Sql Server 2005,
How do I do a search on multiple indexed columns?
If I have courses as my table and courseText and keywords as my columns
indexed, how do I tell it to search on both columns?

This is an extension of my previsous post.
I have a few lines of code where I am trying to fill the variable @ROI based
on condition of a field. Thus if there
DECLARE @ROI varchar(30)

Recently, I have had a discussion with my database administrator about
performance issues reported by the end-user. Finally, we had two
contradicting views about the source of the problems.
The generation of some sort of reports took a long time and it was

I need to downgrade one of my 2-node cluster from build 9.00.3215 (CU5) to
9.00.3042 (SP2). Is there anyway that this can be done without having to
completely uninstall SQL Server 2005 first, and then reinstall SQL 2005 SP2,
without CU5?

I have couple of tables and am trying to extract the value based on
calculation in a variable named ROI.
The following is the incorrect code:
If  (((dbo_PWOPayback.AnnualVolumePer1000) *

Is it possible to use a single partition functions and partition
schemes for multiple tables.
Ex. TableA(EmailId,SendDateId)
     TableB(EmailId,SenddateId,OpenDateId)

I've been consistently getting some strange errors such as: Unable to check
version on remote machine when executed by a domain/user account.
Our help desk said to change the owner of the job to 'sa' for the time being.
I've changed the job owner to 'sa' but it still executes the ...

I'm trying to add more characters into existing records on SQL database,
I've been used the UpdateText command, however it is work for column with
datatype as text, ntext or image, in my case I have varchar.  Is there
command on SQL 2005 similiar as UpdateText?

Hello we have an application which requires the abilty to return the
Top n of a dataset. We are using a variable in an SP to provide the
number of records required.
What the user would also like to see is the number of records in that

Is there any way - 'SA' account can be disabled in SQL Server 2000 ?
Base on a recent audit we are replacing SA account with a new sql login
account.
In 2005, is there any way we can change the ownership of the system database

I an it issues invoice # 99new to SQL and have a problem with our
application which is a web based written on ASP. During the selection to
create the invoice it returns invoice # 100000 which I thought was fine but
after generating more invoices they are all generating with the ...

I have this XML from MSDN
declare @x xml
set @x = '
<People>

I'm new to restoring databases in SQL 2005, so I thought that I would do
some testing here on my laptop in case I ever run into the need to restore a
database and transaction logs in "real life" to conduct point in time
recovery.  So, I backed up a test database and conducted one ...

I had an old application running on SQL 2000 - SQL DB and Analysis Services,
under Window 2000 - NT Domain.
I am moving the solutions to Window 2003 with a new server name and in
Active Directory.

We have an in house application that uses SQL to store support cases and
occassionally a user will complain that support cases were deleted.  
My guess is that someone might be deleting the records but I don't want to
tell her that unless I'm sure that's the case.