Connect Two Databases Together

I am interested in having two databases that are on the same server
connected together. I have the individual databases but I also want to have
a common database that keeps stored procedures to do things such as changing
password. I don't want to cut and paste them into each database each time
plus if I ever made a change I am creating a lot of work for myself.
Users would have the same login and password for the two databases. What is
the simpliest way to set this up?
Thanks
Can
There are several options, ranging from linking tables, to managing them
both with common scripts. It really depends on why you want them to be
separate databases instead of a single database, and then why you want
certain things in common -- ease of maintenance, security, or something
else?
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Can" <Can@.discussions.microsoft.com> wrote in message
news:74E21166-FD11-46E5-AF30-A7415D2D331D@.microsoft.com...
> I am interested in having two databases that are on the same server
> connected together. I have the individual databases but I also want to
> have
> a common database that keeps stored procedures to do things such as
> changing
> password. I don't want to cut and paste them into each database each time
> plus if I ever made a change I am creating a lot of work for myself.
> Users would have the same login and password for the two databases. What
> is
> the simpliest way to set this up?
> Thanks
> Can
>
|||I am looking to llink stored procedures, not tables, from one database to
another for ease of maintenance. What direction do you suggest?
"Jeff A. Stucker" wrote:

> There are several options, ranging from linking tables, to managing them
> both with common scripts. It really depends on why you want them to be
> separate databases instead of a single database, and then why you want
> certain things in common -- ease of maintenance, security, or something
> else?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "Can" <Can@.discussions.microsoft.com> wrote in message
> news:74E21166-FD11-46E5-AF30-A7415D2D331D@.microsoft.com...
>
>