It depends on the severity that you set. From BOL:

A RAISERROR severity of 11 to 19 executed in the TRY block of a TRY…CATCH construct causes control to transfer...

Excellent article Jacob, however, there is one thing that I must take issue with. The following statement:

By using sp_executesql to execute your dynamc query (instead of EXEC() ) you...

I have tested this my last posted query on one of the few SQL 2000 servers that I still have access to and it worked fine, and I can think...

OK, I think that you are getting an overflow of the Decimal type range that you are using. That was OK when you were using Decimal(17,8), because that was...

Karthik: please post the exact error that you were getting.

I'll have to check, but I don't think that you should hav...

OK, this should correct thos errors:

declare @sql varchar(8000)

Declare @DB_Objects varchar(8000)

Select @DB_Objects = ' name COLLATE DATABASE_DEFAULT as [Name], uid, status, sid, createdate, updatedate

From %D%.dbo.sysusers

'

Select @sql = 'SELECT * FROM

(Select '+Cast(dbid...

Include VALUE in the index _dta_index_QUESTION_RESPONSES_T_8_1557580587__K5_K4 as a covered column:

DROP INDEX [_dta_index_QUESTION_RESPONSES_T_8_1557580587__K5_K4] ON [dbo].[QUESTION_RESPONSES_T]

GO

CREATE NONCLUSTERED INDEX [_dta_index_QUESTION_RESPONSES_T_8_1557580587__K5_K4] ON [dbo].[QUESTION_RESPONSES_T]

([SURVEY_RESP_ID0] ASC,[Q_ID0] ASC)

INCLUDE (VALUE)

WITH (DROP_EXISTING=ON, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

Try this:

declare @sql varchar(8000)

Declare @DB_Objects varchar(8000)

Select @DB_Objects = ' name COLLATE DATABASE_DEFAULT as [Name], uid, status, sid, createdate, updatedate

From %D%.dbo.sysusers

'

Select @sql = 'SELECT * FROM

(Select '+Cast(dbid as varchar(9))+' as DBID,...

Let us know if you need anything else, Helmut.

Jeff Moden (8/28/2008)

---

It's also part of the reason I wrote that forum ettiquette article on how to provide actual test data so that good folks like yourself don't have...

Actually, I probably only need the definition, keys and indexes for [question_responses_t].

OK, there's nothing obvious in the execution plan. We'll need to see the table definitions including the keys and indexes.

This is a corrupted execution plan file. Please re-save it as a *.sqlplan file and attach it to a reply.

Yes, but what defines the Order?