How to connect two databases on alocal server in SQL

Hello , This is Vidya newly joined to this group.
I want some help .... Its really urgent

In my project I want to connect to two databases on alocal server in SQL ? Is there any SQL query to connect two databases ?

Situation is=>
There are two Databases Db1, Db2. I want to take data from tables of Db1 to data of tables of Db2 and vice versa.I want simple SQL query without any scripting language or VB statements. Its very urgent Please help me in that.If the two databases are on the same server you can reference either one in the other by using the fully qualified object name: [database].[owner].[object]|||Thank You Sir, For your quiock reply. I have tried it but still I am unable to connect.

Sir can we have '-' (Hyphen Character) for our database name? like a_com_-_b, Is It a valid name...

Thank You|||Yes, database names can contain hyphens. But I would not recommend it for reasons of style.

Post the code you are trying that is not working. You should be able to do something like:
Use Database1
go

select Table1.Column1,
Table2.Column2
from Table1
inner join Database2.dbo.Table2 as Table2 on Table1.pkey = Table2.pkey

How to connect 2005 express

I installed SQL Server 2005 Express in a computer to replace MSDE.
Now I cannot connect it on my SQL Server Group with Server Enterprise
Manager.
Thanks
Did you enable remote access?
"M" <mxchen@.hotvoice.com> wrote in message
news:Onz7tSJDGHA.2036@.TK2MSFTNGP14.phx.gbl...
> I installed SQL Server 2005 Express in a computer to replace MSDE.
> Now I cannot connect it on my SQL Server Group with Server Enterprise
> Manager.
> Thanks
>
>
|||Enterprise manager can't mange SQL Server 2005 instances correctly. The
reason EM doesn't see it is probably because you haven't enabled and started
the sqlbrowser and enabled networking for your Express instance but even
when you can see it, EM won't be able to manage Express because it is not
forward compatible.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"M" <mxchen@.hotvoice.com> wrote in message
news:Onz7tSJDGHA.2036@.TK2MSFTNGP14.phx.gbl...
> I installed SQL Server 2005 Express in a computer to replace MSDE.
> Now I cannot connect it on my SQL Server Group with Server Enterprise
> Manager.
> Thanks
>
>
|||Yes. but The Server Enterprise Manager is 2000 version
"Martin" <mpennings@.wanadoo.nl> wrote in message
news:43b42163$0$208$dbd41001@.news.wanadoo.nl...
> Did you enable remote access?
> "M" <mxchen@.hotvoice.com> wrote in message
> news:Onz7tSJDGHA.2036@.TK2MSFTNGP14.phx.gbl...
>
>
|||It won't work, I just tried myself. Enterprise manager is not compatible.
You'll need another tool.
"M" <mxchen@.hotvoice.com> wrote in message
news:%23W7jz6LDGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Yes. but The Server Enterprise Manager is 2000 version
> "Martin" <mpennings@.wanadoo.nl> wrote in message
> news:43b42163$0$208$dbd41001@.news.wanadoo.nl...
>
>
|||It has been mentioned before, you can download it from:
http://www.microsoft.com/downloads/d...displaylang=en
"M" <mxchen@.hotvoice.com> wrote in message
news:%23W7jz6LDGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Yes. but The Server Enterprise Manager is 2000 version
> "Martin" <mpennings@.wanadoo.nl> wrote in message
> news:43b42163$0$208$dbd41001@.news.wanadoo.nl...
>
>
sql

How to confirm File group is Currupt

How do we will come to know, whether file group is currupted or notTry DBCC check