Linking tables in SQL server 2000 ? 1

[Guest_imported]

I am currently running access 97. I have about 400 queries so to keep it looking good we break eack client into its oven mdb. Then to work on the same data we link our tables to the main database. Once that is done we run our queries against the linked tables which is updating the main database. Now we are converting to SQL 2000 and won't to keep our stored proc broken up by client (if I put all 400 in the same db it will look very cluttered.

All I am really asking is if I can link tables in SQL like I can in access.

Thanks in advance
David

 

[nickb]

Have you thought about using views to link your tables and then run the stored procedure on the views.