As always when "big brothers" are watching ... shivers in the spine :Whistling:

I've also tested at 32-bit Dev Edtn SP2 CU5 on 2-way XP sp2.

Same issue. :crying:

You could off course include a

NET USE ... user:yyy pasword:yyy

don't forget to clean up after teh copy !

NET HELP USE provides more info

The tests I performed were using SSMS2005.

At the client I also did install sp2 + CU5 !

(client installs are forgotten for updates way to much)

I've tested your scripts at SQL2005 DE sp2 CU5

and SQL2000 PE SP4

with no problem at all.

these are results:

SQL2000 PE sp4

(1 row(s) affected)

col1 col2

-----------...

if you want to use xp_cmdshell, you'll have to open it at sqlserver instance level ! (which I do not advise !)

We use a SQLAgent job to perform the backups.

The...

Oh certainly a huge yes regarding SP-release :exclamationmark:

Why, because IMHO a SP is considered to be a stable release, tested well by the manufacturer. Certainly worth a general test and...

There are the resulte of the test I performed :

(sql2005 dev edtn SP2 CU5)

set nocount on

-- is "Ad Hoc Distributed Queries" enabled ? if not, enable it

declare @SQLConfigOption varchar(256)...

I'm very sorry to have to tell you that it fails with partitioned objects on SQL2005.

I've tested it on an x64 EE SP2 CU2 4-socket-dualcore 16Gb

I have added the...

Phil, Chris,

Indeed no discussion regarding the use of target variables.

The point is, will its content be correct during the setbased work

if the variable is used more then once in...

Very good article, nice testcode. :w00t::cool:

There may be some testing needed regarding parallelism,

maybe for now just add a OPTION(MAXDOP 1).

The only remarks I would add to the conclusion is...

Just replace the @var with the column name in the select clause.

I tend to test with @-variables so there is no residue left behind afterwards.

Glad you figured it out 😉

IMO Bulk Insert (check BOL) is what might serve you better.

e.g.

BULK INSERT mydb.myschema.myobject

from '\\UNC_path\myobjectdata.txt'

WITH

( FIELDTERMINATOR = ''

--,CODEPAGE =...

So is this what you are looking for ?

declare @myfile varchar(256)

set @myfile='D:\MailRoomImporter\incoming_documents\releases\OC\11000248.pdf'

Select datalength(@myfile)

SELECT @myfile

, substring(@myfile, 40, datalength(@myfile)) as TheRest

, CHARINDEX('\',substring(@myfile, 40, datalength(@myfile)),1) as theslash

, substring( substring(@myfile, 40, datalength(@myfile)), 1,...

You'll have to name those columns (in the exact sequence as needed for your target table) from the source table.

Using query analyser, in the object explorer, rightclick the source table,...

thank you for the feedback (urls and demo script) 😎