I am attempting to add
schemabinding to a view in SQL Server 2008, but I am getting an error of
Syntax 'Openrowset/Openquery/Opendatasource' is not allowed in schema-bound objects.
I am using
Openquery because I am querying a linked server and this is the way I must query it. Is there a workaround for this?
This was the syntax I tried with my view
Create View dbo.Test With Schemabinding As Select * FROM OPENQUERY(18.104.22.168, 'Select * from ls1prod.hrinfo') Go