Maybe u have to set db compatible level

Hi kanasz.robert,

What you are tolking about puzzles me for a long time. :crying:

keep watching.

tks

Just test as follows:

--========================Linked Server creating

EXEC master.dbo.sp_addlinkedserver @server = N'LENOVO\SQL2005', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LENOVO\SQL2005',@useself=N'False',@locallogin=NULL,@rmtuser=N'USDBA',@rmtpassword='USDBA'

GO

EXEC master.dbo.sp_serveroption @server=N'LENOVO\SQL2005', @optname=N'collation compatible', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'LENOVO\SQL2005', @optname=N'data access', @optvalue=N'true'

GO

EXEC...