Ive also just tried this function that should remove any CR LF Tab, spaces, etc, but that made no difference, this has really got me stumped

where do i add that ?

ok, there are some setup scripts as part of the project which I cant change since there are several developers working on this and they all expect the same instance...

how do I do that ?

ok, got it to work, the node is actually underneath a root node which id left out

Im going to be specifying the version in a variable (Ill build a stored procedure because its to be run from within a .net app), so Ive now got this

DECLARE...

finally sorted it, closing down management studio released the transaction, its back to normal now, thanks for your help though.

it was in a stored procedure

I think the problem is that I initially commented out the commit statement, that seems to have caused the problem. How can i kill the locks ? can...

how would i find out if its blocked ?

yeah I included a commit statement and a rollback in a try catch construct if there was an error

Ive tried BCP but always get an error

The data type for input column is DT_NTEXT

how would i use native format ? any examples ?

i need to setup some sort of script (or package) to do this. I wont have control over the destination since its on a live server that i dont...

its a text column

ah, ok, so Id have to script the entire database and select the 'include index' option. Seems a bit odd that I cant script indexes on individual tables