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...

The problem with joining you might need to join more than once, or even more than twice. You need to create an alternate method.

For reference you should google "Trees in...

Create table #T1 ( [USER_ID] int,  MAILBOX_TYPE smallint)

insert into #t1 ([User_ID], Mailbox_Type)

select 1090,2 union

select 1092,2 union

select 1093,2 union

select 1094,2 union

select 1095,1 union

select 1097,2 union

select 1098,2 union

select 1099,2 union

select 1100,2 union

select...