Thanks I think I have got it now it was the printing .

Here the entire code and it works a treat.

DECLARE @START INT,

@END INT,

@@CONCAT_PROJ VARCHAR(MAX),

@PROJ_ID NVARCHAR(30),

@ID...

No i even saved it to a physical text file and brought it back in and the variable is not holding all the data.

I am just reading a table that has the data in it.

I still need to get the string back into SQL to update a table with the concatentated string. ...

If you have a choice go with RAID 10.

It is not that simple just to do 250 GIG for MDF and LDF. For max performance it is how you...

4000 is high ..where are the logins coming in from web pages ? Do you have to keep resetting the IIS Recycle. I thought there was a setting...

Set the min and max. Also do the windows lock in memory. Without this set I noticed that setting the max did nothing. Hope that helps.

Download the SQL Advisor tool this will tell you a lot about the problems before you do the upgrade from sql 2005 to sql 2008. It is part...

I will take a look at the EXCEPT condition.

Thanks

The no-locks are not doing anything. I found that there is a global isolation registry key I can set in version 8.5 it was uncommitted and version 9 committed...

Thanks for all your help. If i select display in text mode it appears to be working.

Cheers

Wow didn't know you could do that. Thanks.

Do you know how to get rid of the exception error at the end so I can process more records.

The service pack 2 put the mssqlsystemresource1.mdf files in the default directory in our case P Drive. So I managed to move the mssqlsystemresource1.mdf files to the U Drive...

Resolved.

Thank multiple content databases. Will look into this.

Thanks I will recommend upgrade to 2010 as soon as it out rather than in 5 years 🙂