I guess that if you build the whole string in dynamic sql, it'll work then using something like this.

...

'rowdelimiter = ''' + char(10 + '\n'''

Maybe there's another way but I...

I see at least 10 converts in your execution plan.  So the server obviously thinks otherwise.

BTW varchar(9) <> nvarchar(9) <> [n]char(9).

Is there any collations differences between the tables or between...

You'd be better off to use IF EXISTS.  It'll return true or false instead of the row count.  On small table it's not a big problem but those things add...

Have you tried the 2nd version of the code (2nd link, 5th message).

You'll nothing that he is using set fmtonly on.  I don't remember why exactly he used it but...

I would think you'd have to paste the character directly in the code... I can't seem to do something like :

ROWTERMINATOR = CHAR(10) + '\n'

I'll...

I just completed my previous answer... Does that clear it up for you?

I don't know what else to tell you...

this compiles fine on my computer :

select a.* into ##tmptesting FROM OPENROWSET('SQLOLEDB','ServerName;UID;PWD','sptest1 10,''Y''') AS a

But I have no way of executing it...

Well first read this in books online :

data types-SQL Server, precedence

Basically the server must convert the data when the 2 sides of the operations have different datatypes.  The convert...

Open the file with notepad, highlight the character, then copy hit to the clipboard.

Go in query analyser and type this :

SELECT ASCII('

paste the character and type

')

Execute and you'll the...

Shouldn't be any trouble... they'll just have to make a 2nd connection string and use that string in a few pages... if the app is well coded it won't be...

Can you do a replace in the text file before importing??

Can you use a unicode text import (sorry but I don't know the real name of that option, just that...

I knew I was missing something... Check this version of the code... maybe that'll solve it :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=99415#bm99871

Never had that problem.  Have you tried " EXEC dbo.sptest1 10,'Y' "

I found this old thread but I'm not sure it's gonna be much use to you at this point...

DECLARE @demo TABLE (MyDate DATETIME NOT NULL PRIMARY KEY CLUSTERED)

INSERT INTO @demo (MyDate)

SELECT DATEADD(D, 1, GETDATE())

UNION ALL

SELECT DATEADD(D, -1, GETDATE())

UNION ALL

SELECT GETDATE()

SELECT MyDate FROM @demo

SELECT MyDate, GetDate() FROM @demo WHERE...

Select name from dbo.SysObjects WHERE XType = '1'

--0 row(s) affected

--perfectly normal

Select name from dbo.SysObjects WHERE XType = 1

--This crashes so bad that the execution plan is not even...