Connect to anothe database

[Guest]

Hi EveryBody:

How can I connect to another database instaed of the default database
aspnetdb in the local SQL Server in the App_Data folder that exist in my web
site application ?

My database that I want to connect is in my local Machine and its name=Husam.

Any Help or redirection will be completely appreciated

regard's

Husam

 

[William \(Bill\) Vaughn]

It's easy. Assuming the credentials have access rights to the other
database, simply add the name of the database to the Table name.

SELECT Author FROM dbo.Authors
becomes

SELECT Author FROM Pubs.dbo.Authors

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)