AnzioBake is correct.

BOL 2000 states, When SET QUOTED_IDENTIFIER is ON, all strings delimited by double quotation marks are interpreted as object identifiers

create table Temp (a text,...

Have a look at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

Read in SQL Server Books Online about TEXT, READTEXT and WRITETEXT.

I think it depends on the severity of the error, some of the errors abort and rollback the transaction and it will be difficult to trap in SQL. Can't you...

Can you supply a bit more info, error number, maybe code, etc.

The LOG function with a negative value can cause this error.

Can you step through the code with the debugger in Query Analyzer

Will check it at home tonight(now...

How often does it occure

You do your update stats, defrag, checkdb, etc. stuff

Can you post the code

Guess some funny/invalid value somewhere.

Example:

    Select SQRT(-10)

Bug in function.

Create Function ResolveFunnies(@Arg varchar(8000)) 

Returns @Answers Table (v Varchar(8000)) As

Begin

Declare @Tmp Table(Cnt Int,v varchar(8000))

Declare @v Varchar(1000),

@Cnt Int

Set @v='['

Set @Cnt=0

Insert @Tmp 

Select 0,PlaceHolderText From Tmp1

Select...

Need a bit more work but may help a bit

Set Nocount On

GO

Create Table Tmp1(ID int,PlaceHolderText varchar(100))

GO

Insert Tmp1 values(1,'Hello [Name], is your age [Age]...

Did not add part to remove old data and to add the new aggregated data.

Hopefully this is not to far of the target

Set Nocount On

Create Table TMP(objectId UNIQUEIDENTIFIER,statsType INT,dtCreated DATETIME,hits INT DEFAULT 1)

GO

Declare @n UNIQUEIDENTIFIER

Select @n=NewId()

INSERT TMP(ObjectId,StatsType,dtCreated)...

See SQL Server Books Online for the Case statement.

See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15762&FORUM_ID=8&CAT_ID=1&Topic_Title=T%2DSQL+%22shortcut%22%3F&Forum_Title=T%2DSQL

Have a look at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15744&FORUM_ID=9&CAT_ID=1&Topic_Title=parsing+text+data+type&Forum_Title=General

Sounds like something has not been recompile/updated? Used to use Smart Viewer and remember the TTX files needed to be updated.