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
BEN-405167
SSC-Addicted
Points: 470
More actions
August 11, 2007 at 9:24 am
#726288
I tried this but i get :
The name 'USE db_presmon_dwh_9;CREATE TABLE dbo.ETL_TEST (LAAD_KEY bigint IDENTITY (1, 1) NOT NULL , LAAD_DATUM datetime NOT NULL) ON [PRIMARY]' is not a valid identifier.