Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
koji
Starting Member
1 Post |
 Posted - 2008-08-06 : 16:46:09
|
| create view vw_Cliente with schemabinding as select a.nome, d.endereco, d.bairro, d.cep, d.estado, d.cidade c.ddd, c.telefone from a.dbo.nome as a with(nolock) left join b..endereco as b with(nolock) on a.pessoaid = b.pessoaid left join b..telefones as c with(nolock) on a.pessoaid = c.pessoaid When a i try create this VIEW:Server: Msg 4512, Level 16, State 3, Procedure vw_Cliente, Line 4 Cannot schema bind view 'vw_KOJI' because name 'a.dbo.nome' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself. Ps: Remmenber this tables is same server. |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-08-06 : 16:57:20
|
| a.dbo.nome is three parts. Count them.You can't schema bind to a table that is in a different database, even if it is on the same server.e4 d5 xd5 Nf6 |
 |
|
|
|
|
|
CREATE VIEW WITH SchemaBinding