December 8, 2003 at 9:24 pm
I was wondering if it was possible to use two MS SQL databases for one App. I have a customers db which has tables that hold user specific information. I also have tables that track information requests. I am going to develop an app that will allow tracking of which representitive is assigned to handle a specific request for information. The problem is I dont want to have an employee table in the customer table and I am a newb so does anyone have any suggestions Please. Thanx
December 8, 2003 at 11:38 pm
Sure can. Set the permissions for each db as though it's the only db. If you need cross db joins, the user must be in both dbs adn you qualify the table names as db.owner.tablename in the queries. Or create a view to do this in each db that looks at the other one to make most queries simpler.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 9, 2003 at 10:48 am
Thanks Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply