query

I have 2 database:
first A
second B
in B there is a table X
how can i save a view in A that select the table X in B?
ThanksYes, but not in the query designer. Write TSQL code instead:
CREATE VIEW ... AS
SELECT ...
FROM otherdb.dbo.tblname
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"killer" <matteo.milano@.katamail.com> wrote in message
news:_u5tb.114858$vO5.4451339@.twister1.libero.it...
> I have 2 database:
> first A
> second B
> in B there is a table X
> how can i save a view in A that select the table X in B?
>
> Thanks
>