He is correct, but the method your using to return the record inserted is not good.

Is the Event_Id field an identity?

If so you would be more wise to use

select scope_Identity()

as...

I know thats not possible in sql 2000 but not sure in sql 2005

Backups are always taken from the primary db. you should take the db backup, for that day,...

This is a great site for sql dts help.

http://www.sqldts.com

Your going to want to look at lookups

http://www.sqldts.com/default.aspx?277

Or I usually elect for a simple solution. involving a few separate steps.

Create...

look up sp_Detach_db, and sp_Attach_db in books online.

Look Up BCP. It will extract data and save to text file.

Stored procedures cannot easily do this unless you use a sp_cmdshell.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_bcp_61et.asp

Bummer!!

Can you elaborate on this?

There ya go, thats the way.

Hardware looks good.

Hard to say.

More linkage:http://www.mssqlcity.com/Tips/tipSQL2000.htm

Not all the recommendations are "Guaranteed" Before you implement a change make sure you test it.

As I said before

Make sure your indexes are all...

I don't know, I was reading on MSDN when I looked up Readtext it notes that the readtext function is going away.

and the value you see in query analyzer is...

In Report manager, Click on the report you want to change.

Click the properties tab on that report. Under the description textbox there is a link

Hmm, I'm stumped, the iif appears to be structured properly.

It throws an error because you cannot do this.

Text values greater than 8k cannot be stored in a page of memory therefor you cannot assin the value to a variable,...

Well,

If you execute this code alone, how many records are returned?

select substring(name,1,30) as Banco,

               CAST( ( FILEPROPERTY( name, 'SpaceUsed' ) *  ) / 1024 AS numeric( 10, 2) )

FROM sysfiles

More...

Here Ya Go

DECLARE @idoc int

DECLARE @doc varchar(8000)

SET @doc =

'<?xml version="1.0" encoding="UTF-8"?>

<aaa:aaa-msg

    xmlns:aaa="http://www.company.com/Schema/aaa"

    xmlns:bbb="http://www.company.com/Schema/bbb">

 <aaa:header>

         <aaa:eid/>

         <aaa:reference_id>1234</aaa:reference_id>

         <aaa:event_date>JAN 10, 2003 02:07:21

PM</aaa:event_date>

         <aaa:sr_type_code>DIRTYWAT</aaa:sr_type_code>

         <aaa:event_type_code>REQUEST</aaa:event_type_code>

         <aaa:eai_event_code>XAPPSR</aaa:eai_event_code>

         <aaa:source_code>SIDEWALK</aaa:source_code>

         <aaa:target_code>PRIMAPP</aaa:target_code>

         <aaa:status_code />

         <aaa:details/>

 </aaa:header>

 <aaa:body>

  <bbb:document>

  ...

We would need more information about your hardware setup.

There are sooooo many things that could be happening your situation it would be impossible to guess.

Too many indexes can cause problems.

First...