thanks so much!!!

I change the view with OpenQuery function.

and I will investigating until continue find the explanation about that situation.

yes It works!

do you know why the before sentence don't work?

and why with sql server 2005 work perfect too?

I'm a women who want to know why the things happen. 😉

thank.

ummmm

Is not correct the result

because when I say Select * FROM OPENQUERY(,'SELECT * FROM DB.dbo.V')

The select execute the View from server B. this View in server B have...

you mean,

Alter View V......

I do, and the view work perfect.!!!!! 😛

but, I want to know WHY If I run Select * from V I have this strange error. with...

the result is

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'AS'.

yes the error is if I run :

Select * From V (from server A)

--- I don't Put the name of the link server because remember in server B...

not,

I have the same error:

Msg 8180, Level 16, State 1, Line 1

Statement(s) could not be prepared.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "Tbl1010.Monto" could not be bound.

Msg...

ok, ok, I put select permission and the view V, and run again, the sentence openquery run perfect but why the view don't ???

No,

the result is:

OLE DB provider "SQLNCLI10" for linked server "B" returned message "Deferred prepare could not be completed.".

Msg 229, Level 14, State 5, Line 1

The SELECT permission was denied on...

partially correct:

3) SELECT * FROM B.db.dbo.V works (if I run in server B)

4) SELECT * FROM B.db.dbo.V (if I run in server A, doesn't work and I get the error...

for the script that I show you the error is : (the column monto and codtipocredito is in the query)

Msg 8180, Level 16, State 1, Line 1

Statement(s) could not be...

I don't know the error put this column and table that I don't have.. but the columns: monto is in the select and codtipocredito is in the where clauses........

this is the script for the link server B in server A, is the same in both server

EXEC master.dbo.sp_addlinkedserver @server = N'B', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'B',@useself=N'False',@locallogin=NULL,@rmtuser=N'USER',@rmtpassword='########'

GO

EXEC master.dbo.sp_serveroption @server=N'B', @optname=N'collation compatible',...

this is the view in server A: SERVER B is the other server when data is retrieve.

(DB is the database)

--NOTE: I only put 2 columns for security reason of the...