resolved with the below query

USE [database];

Go

sp_change_users_login @Action= 'update_one', @UserNamePattern=,

@LoginName=[loginname];

GO

I downloaded the database of mysql from the another server and then I made a linked server off,

what I see now is that it works so my problem is that...

Yes I can

And when I run the below query this works also,

update dt

set dt.quantity =a.as_qtesto-a.as_qteres

from openquery(mysqlapp,'select * from product')as dt

inner join TRACTOV15.dbo.f_artstock as a on

dt.model = a.ar_ref collate database_default

where...

I found it, now it works,

update tabel3

set tabel3.price = dt.ac_prixVen

from openquery (mysqlapp, 'select * from product_special') as tabel3

inner join (select Ar_ref, Ac_prixVen, AC_categorie,product_id, price

from openquery (mysqlapp, 'select * from...

Dear sir,

I am new on mssql (now a little of it) and I saw your post, can you tell me how I can create one linkedserver on sql server 2005...