Thanks everybody for your ideas. I had thought the problem was the number of vars in the IN list but probably the total size of the SQL statement was the...

Yes, it is dynamic sql generated by Cognos. I havent been able to get the sql statement so I can run it in QA and optimize it.

Reason for this method is, the query is from a COGNOS report prompt. When a user selects a contractor, a distinct list of recipients is generated and the only option...

Try using dbcc updateusage.

--JP

-----------------------------------------

This worked. Thanks JP.

I thought there must be a simple solution.

Just tried, didn't fix it.

Thanks, I already tried that with no luck.

Wow.

I don't know much about virus scanners. Our Network Admin installs them and handles firewall issues.

We are running eTrust on that server.

Is there any whitepaper or kb article that...

I rescheduled the backups to run this weekend well after the system backups are finished.

Thanks for the suggestions.

Sorry, neglected to include this in last post.

Check your database options to see if the recovery method hasn't been set to simple. This will cause a tran log backup to...

If you right-click on the Maintenance plan, then click maintenance plan history and find the job that failed and double-click it, you should get a much better error message.

Or you...

Instead of using the 'copy tables...' from the source database, use 'copy objects and data...' from the source database. There is an options button that allows you to include primary...

I just experienced a somewhat similar problem yesterday importing Excel into a SQL 2000 table. The SSNs that didn't have hyphens loaded properly but the the ones with hyphens (123-45-6729)...

I finally got back to fixing the ownership.

Basically, I am having the developers create the procedure with dbo as the owner.

CREATE PROCEDURE [dbo].[spRAB_test] AS

SELECT TOP 100 * FROM cntrl_Client

GO

Then I...

Thanks for all the great responses.

This has been one Frantic Friday so I haven't had a chance to test them yet.

I am using SQL2000.

I did run execution plans and they used index seeks extensively.

Here is what we ended up doing.

The developer was joining several tables; he used 5 Left outer joins and 4...