I attempted to create a view in SQL Server 2000 that Unions two
queries. The first part of the query gets data from the local server,
the second part gets info from a linked server. (The query works fine
in Query Analyzer.)
I received this error when I tried to save the query:
ODBC error: [Microsoft][ODBC SQL Server Driver] The operation could
not be performed because the OLE DB provider 'SQLOLEDB' was unable to
begin a distributed transaction.
[Microsft][ODBC SQL Server Driver][SQL Server][OLE/DB provider
returned message: New transaction cannot enlist in the specified
transaction coordinator.]
After a little reading I discovered the "Database limitation":
"A view can be created on a table only in the database the view
creator is accessing".
That's my problem... is there a simple solution or alternative to
creating a view?
Thanks,
Matt