SQL Server 2008 R2: 'CREATE/ALTER VIEW' does not allow specifying the database name as a prefix to the object name

It is really simple: you need to change the database

USE DB2
GO

ALTER VIEW View1
    ...

Tags:

Sql Server

Sql Server 2008 R2

Recent Posts