Here is what I did.

In Microsoft SQL Server Management Studio I went to db/Storage/Full Text Catalogs and clicked the 'Delete' to remove the index.

Then I did the following:

CREATE FULLTEXT CATALOG...

So I am guessing since I didn't do the same as you it's probably not populated. Should I delete and recreate with your syntax or is there a way...

Thanks.

Here is my db version:

Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows...

That seems to be the trick.

Here is the code with no errors. Should I still add the ISNULL check? I am not sure how you do that...

I tried the following and still get the same Message.

ALTER PROCEDURE [db].[sp_CustomersPartnersChart]

-- Add the parameters for the stored procedure here

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

--...

That was it thanks.

SELECT c.contest_attempts_allowed,

count(ca.ca_status_cd)

FROM contest c LEFT OUTER JOIN contest_activity ca

ON c.contest_id = ca.contest_id

AND ca.p_id = 1 AND c.contest_id = 2

GROUP BY contest_attempts_allowed

Lynn, thanks for the quick reply. However the following didn't return any results:

SELECT c.contest_attempts_allowed,

count(ca.ca_status_cd)

FROM contest c LEFT OUTER JOIN contest_activity ca

ON c.contest_id = ca.contest_id

WHERE ca.p_id = 1

AND...

Yes, that worked. Any documentation on handling multiples?

Yes, I guess I was looking on my local machine.

Forget the .bak file, does anyone know a good way to get 'INSERT' statements without scripting it all out? Is...

In Restore Files and Filegroups, I can select the 'To database:' but in the Source for restore I selected 'From device' but can't paste the location into the box. ...