dec_obrien (7/5/2011)

I'm new to SQL Server 2008. I'm trying to create a new Login in SQLEXPRESS 2008 so that I can connect to the database. I have created a new...

something like this?

DECLARE @pk [type], @var [type]

DECLARE CRSR_TMP

CURSOR FOR

SELECT PK FROM

OPEN CRSR_TMP

FETCH NEXT

FROM CRSR_TMP

INTO @pk

WHILE @@FETCH_STATUS <> -1

BEGIN

...

This works!

execute ('INSERT into INFO VALUES (1004589, 33,9887,''tekst'') ') AT rl_smd01

I had to set the linked_server RPC to true to let it work.

Thanks guys, for all the effort.

Do I...

I've also tried :

INSERT into rl_smd01.zegris__01__nloc03..INFO

VALUES (1004589, 33,9887,@tekst)

(4 part naming)

Same result...

This is the original code:

declare @tekst as nvarchar(1600)

set @tekst = 'test'

INSERT into

openquery(rl_smd01, 'select in_kr_nr, in_record_code, in_kr_key, in_tekst_tabel from info

...

The error message:

OLE DB provider "MSDASQL" for linked server "rl_smd01" returned message "[Liant][Relativity]Invalid precision value.".

Msg 7343, Level 16, State 2, Line 3

The OLE DB provider "MSDASQL" for linked server "rl_smd01"...

This is a fragment of SQL Profiler:

<DBCOLUMNINFO>

<pwszName>IN_TEKST_TABEL</pwszName>

<pTypeInfo>0x00000000</pTypeInfo>

<iOrdinal>4</iOrdinal>

<dwFlags>4</dwFlags>

<ulColumnSize>1600</ulColumnSize>

<wType>129</wType>

<bPrecision>255</bPrecision>

<bScale>255</bScale>

..

The error does not mention the column, but the other values are "normal" int's so I didn't believe it would come from that angle..