4

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(191.183.18.101, 'Select * from ls1prod.hrinfo')

Go
5

The documentation for Indexed Views is pretty clear about what's allowed, and what's not allowed.

Specifically:

ROWSET functions (OPENDATASOURCE, OPENQUERY, OPENROWSET, AND OPENXML)

There's no 'workaround' because it's not allowed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.