none
Error when creating view, which have reference to another database

    Question

  • I have 1 application and 2 databases in SQL Azure.
    The Database1 should include view that select data from Database2.

    When creating view in the Database1 I got error:
    Reference to database and/or server name in 'Database2.dbo.X_Users' is not supported in this version of SQL Server.

    This is the
    CREATE VIEW [dbo].[X_Users]
    AS
    SELECT     *
    FROM         Database2.dbo.X_Users
    GO

    Not possible to create view which have reference to another database?


    Kenny_I

    Friday, February 10, 2012 9:14 AM

Answers

All replies