Home Forums SQL Server 7,2000 General ''CREATE VIEW'' does not allow specifying the database name as a prefix to the object name RE: ''''CREATE VIEW'''' does not allow specifying the database name as a prefix to the object name

  • Is there a reason NOT to use two separate variables and place the view create in its own variable? Or do you end up then having the view placed in the wrong database? Which brings us back to using a fully qualified view name, including database, owner, and view name?